is it possible to join DB node with a manipulation node?
Number of questions are answered here
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
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.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.