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:
https://docs.knime.com/2019-06/db_extension_guide/index.html

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

Hi,

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

Br,
Ivan

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.