Icon

Querying database based on values from another database v2

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 tableSelect LogEntry tableSelect Users tableRuns the select statementOnly request rowswhere date >= '2023-03-01'Retrieve the usersfor the specific Log EntriesRemove any grouping createdby DB LoopingH2 Connector H2 Connector Table Creator DB Writer DB Writer Table Creator DB Query Reader Table Column toDelimited String DB Query Reader Joiner DB Table Selector DB Table Selector DB Reader DB Row Filter DB Looping Ungroup Database ADatabase BUsersCreate Users tableCreate LogEntries tableLog EntriesRead LogEntries TableProduce delimitedString of user idsRead Users tableJoin the retrieved users back to the Log tableSelect LogEntry tableSelect Users tableRuns the select statementOnly request rowswhere date >= '2023-03-01'Retrieve the usersfor the specific Log EntriesRemove any grouping createdby DB LoopingH2 Connector H2 Connector Table Creator DB Writer DB Writer Table Creator DB Query Reader Table Column toDelimited String DB Query Reader Joiner DB Table Selector DB Table Selector DB Reader DB Row Filter DB Looping Ungroup

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-26
Last update: 2024-12-28
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!