Icon

Querying database based on values from another database

Demonstration of using data from one database to query a different database

Database ADatabase BUsersCreate Users tableCreate LogEntries tableLog EntriesRead LogEntries TableProduce delimitedString of user idsRead Users tableJoin the retrieved users back to the Log tableH2 Connector H2 Connector Table Creator DB Writer DB Writer Table Creator DB Query Reader Table Column toDelimited String DB Query Reader Joiner Database ADatabase BUsersCreate Users tableCreate LogEntries tableLog EntriesRead LogEntries TableProduce delimitedString of user idsRead Users tableJoin the retrieved users back to the Log tableH2 Connector H2 Connector Table Creator DB Writer DB Writer Table Creator DB Query Reader Table Column toDelimited String DB Query Reader Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: bbate
Created at: 2023-05-25
On NodePit since: 2023-05-25
Last update: 2024-05-01
Created with KNIME version: v4.7.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!