One approach, possibly easier in terms of maintenance, would be to just join the two queries together (eg with a UNION statement or something similar).
If that’s not an option for whatever reason, you can pull a specific row index (even dynamically) from another datasource while inside a table. I created a rather contrived example to demonstrate; datasource A is an ascending list of integers from 0 - 100, while datasource B is a list of descending numbers from 100 - 0. Within the table for A, I entered the following expression in the second column:
@B[Row - 1].Column B@
Then you’re able to pull back the data at a specific index of datasource B based on the row you’re at in the table for A. A project export to better explain what I mean:
Keychain Index.proj (17.5 KB)