join DB node with a manipulation node

is it possible to join DB node with a manipulation node?

Number of questions are answered here

1 Like

You could read about DB nodes here:

For your task the DB Merge node might be the right one but that depends on what you want to do with your data

In the GroupBy node I have a list of identification codes to use as a join key to extract a series of data instead present in the DB Table Selector node


yes if you use DB Reader after DB Table Selector node :wink:


1 Like

Hi nik80,
I assume you have a unique concatenated list after your groupby node. You can use the tablerow to variable node and use this together with the selection statement “where [column] in([$$variable]$$)” within your sql statement to filter your data before retrieving the whole table.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.