Icon

In database queries

There has been no title set for this workflow's metadata.

Querying database based on values from another database

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

Set up a demo database Some techniques for "In Database" queries Build part of a local lookup as case statement clauses for injection into SQL Query Database AUsersCreate Users tableCreate LogEntries tableLog EntriesSelect from Usersusing a"subquery" viewfixing nullsSelect from Log Entriesdirectly as a tableleft outerjoin users to logacts as a case statementbut numeric values as input onlyLocal Office Lookupcreate each case clause"office case clauses"variableapply case statementNode 26 H2 Connector Table Creator DB Writer DB Writer Table Creator DB Table Selector DB Table Selector DB Joiner DB Numeric-Binner Table Creator String Manipulation GroupBy Table Rowto Variable DB Query DB Reader Set up a demo database Some techniques for "In Database" queries Build part of a local lookup as case statement clauses for injection into SQL Query Database AUsersCreate Users tableCreate LogEntries tableLog EntriesSelect from Usersusing a"subquery" viewfixing nullsSelect from Log Entriesdirectly as a tableleft outerjoin users to logacts as a case statementbut numeric values as input onlyLocal Office Lookupcreate each case clause"office case clauses"variableapply case statementNode 26H2 Connector Table Creator DB Writer DB Writer Table Creator DB Table Selector DB Table Selector DB Joiner DB Numeric-Binner Table Creator String Manipulation GroupBy Table Rowto Variable DB Query DB Reader

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-12-23
Last update: 2024-11-24
Created with KNIME version: v5.2.0

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

Try NodePit Runner!