join DB node with a manipulation node

[nik80]

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

[izaychik63]

Number of questions are answered here

[mlauber71]

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

DB Merge — NodePit

[nik80]

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

[ipazin]

Hi,

yes if you use DB Reader after DB Table Selector node

Br,
Ivan

[morpheus]

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.