Query In-Memory

You can query dataframes in any part of the workflow by adding a Query In-Memory node. Connect as many nodes as needed to the Query In-Memory, where their outputs are dataframes. Then when you open the node, you will find all these dataframes with their fields listed in the aside part.

Now you can write a query using any of these dataframe as the tables. Check the screenshot below.