Multiple Connections

Posted 24 days ago by Nathan Gayeski

Post a topic

Nathan Gayeski

Answered

0 Votes

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

Example

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

Thanks!

0 Votes

Gabriel Michaud posted 24 days ago Admin Best Answer

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,...)))

0 Votes

5 Comments

Nathan Gayeski posted 23 days ago

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

0 Votes

Gabriel Michaud posted 24 days ago Admin

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.

0 Votes

Nathan Gayeski posted 24 days ago

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

0 Votes

Gabriel Michaud posted 24 days ago Admin Answer

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,...)))

0 Votes

Markens Juste posted 24 days ago Admin

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?

0 Votes