Icon

Demo DB IN Clause using Flow Variable

User InputMake choice variable into a rowUngroup it sowe have each item as a rowregroup asa concatenated stringConcatenate with justcommaTurn it back intoa variableCreating an IN List withnumeric concatenated stringSome databaseSample databasetableCreate sample db tableTurn it back intoa variableUser InputMake choice variable into a rowUngroup it sowe have each item as a rowregroup asa concatenated stringConcatenate with','specified invalue delimiterCreating an IN List withSTRING concatenated stringAdd the missing start andend quotesCreate StringArray Variable Variable toTable Row Ungroup GroupBy Table Rowto Variable DB Query Reader H2 Connector Table Creator DB Writer Table Rowto Variable Create StringArray Variable Variable toTable Row Ungroup GroupBy DB Query Reader String Manipulation User InputMake choice variable into a rowUngroup it sowe have each item as a rowregroup asa concatenated stringConcatenate with justcommaTurn it back intoa variableCreating an IN List withnumeric concatenated stringSome databaseSample databasetableCreate sample db tableTurn it back intoa variableUser InputMake choice variable into a rowUngroup it sowe have each item as a rowregroup asa concatenated stringConcatenate with','specified invalue delimiterCreating an IN List withSTRING concatenated stringAdd the missing start andend quotesCreate StringArray Variable Variable toTable Row Ungroup GroupBy Table Rowto Variable DB Query Reader H2 Connector Table Creator DB Writer Table Rowto Variable Create StringArray Variable Variable toTable Row Ungroup GroupBy DB Query Reader String Manipulation

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: BATEB031
Created at: 2022-10-14
On NodePit since: 2022-10-14
Last update: 2024-04-27
Created with KNIME version: v4.6.3

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

Try NodePit Runner!