Icon

24_​DB_​Looping

DB Looping Example

This workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL query that uses the values from the input table as value list which is usually used in an IN SQL statement.

The workflow lets the user select any number of clusters that are available in a database table. The selected cluster values are used in the DB Looping node to retrieve all rows that contain any of the selected clusters.








DB Looping ExampleThis workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL querythat uses the values from the input table as value list which is usually used in an IN SQL statement.See further Workflow details by clicking: View > Description Node 5Replace with any database connector nodeUse selected clusters in the IN queryExecute and opennode dialog to selectcluster to read intoKNIME Analytics PlatformDB Table Selector Connect to DB andcreate example data DB Looping Select clusterto read DB Looping ExampleThis workflow demonstrates the usage of the DB Looping node. The node allows the user to write a SQL querythat uses the values from the input table as value list which is usually used in an IN SQL statement.See further Workflow details by clicking: View > Description Node 5Replace with any database connector nodeUse selected clusters in the IN queryExecute and opennode dialog to selectcluster to read intoKNIME Analytics PlatformDB Table Selector Connect to DB andcreate example data DB Looping Select clusterto read

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: Tobias
Created at: 2022-06-03
On NodePit since: 2024-04-10
Last update: 2024-05-02
Created with KNIME version: v4.6.0
Tags: DBRead/WriteDB LoopDB LoopingSQLIN ClauseRelease 4.6

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

Try NodePit Runner!