Multiple Connections

Q&A
1

Hello, is there a way to query on multiple connections?

Example

SI.EXPANDLOCATIONRANGE(Connection 1;Connection 2,Range))

Thanks!

2

Hi, Nathan,

Velixo can only query one connection at a time. If you want to use the SI.EXPANDLOCATIONRANGE function on multiple connections, you will need to use the function for each location in a different cell in Excel.

What is the reason for the need for multiple connections? Are you trying to build a specific report to compare some Data?

3

Nathan,

One thing you could do is use the UNIQUE() and HSTACK() functions to join together the locations from multiple connections:

=UNIQUE(HSTACK(SI.EXPANDLOCATIONRANGE(Conn1,…),SI.EXPANDLOCATIONRANGE(Conn2,…)))

4

Thank you both. We are trying to create global reconciliations between bank and ledger. I will test that out.

5

How many connections do you intend to consolidate? We may look into adding the ability to support multiple connections in the connection argument in the future if that makes sense.

6

For this purpose it would be only a couple but potentially could be in the 100s if it works well.