Icon

Demo DB IN Clause using Flow Variable2

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 quotesselect Product tableBuild IN clausefrom a selection table"selection" tableUsing an IN database IN clauseIN Clause addedDirectly in the Table SelectorCustom QueryNode 27Node 28Create 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 DB Table Selector DB Looping Table Creator DB Query DB Table Selector DB Reader DB Reader 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 quotesselect Product tableBuild IN clausefrom a selection table"selection" tableUsing an IN database IN clauseIN Clause addedDirectly in the Table SelectorCustom QueryNode 27Node 28Create 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 DB Table Selector DB Looping Table Creator DB Query DB Table Selector DB Reader 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: 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!