For this purpose it would be only a couple but potentially could be in the 100s if it works well.
0 Votes
Gabriel Michaudposted
15 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
N
Nathan Gayeskiposted
15 days ago
Thank you both. We are trying to create global reconciliations between bank and ledger. I will test that out.
0 Votes
Gabriel Michaudposted
15 days ago
AdminAnswer
Nathan,
One thing you could do is use the UNIQUE() and HSTACK() functions to join together the locations from multiple connections:
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
Hello, is there a way to query on multiple connections?
Example
SI.EXPANDLOCATIONRANGE(Connection 1;Connection 2,Range))
Thanks!
0 Votes
Gabriel Michaud posted 15 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 15 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 15 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 15 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 15 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 15 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
Login or Sign up to post a comment