Icon

Demo DB IN Clause using Flow Variable3

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 28Node 29Make variable intotable cellUngroup the set/listinto separate rowsSplit on comma as set or list. Trimany whitespace off endsGive it a friendly name for the DB Looping nodeBuild IN clausefrom a selection tableCreate 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 String Widget Variable toTable Row Ungroup Cell Splitter Column Rename DB Looping 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 28Node 29Make variable intotable cellUngroup the set/listinto separate rowsSplit on comma as set or list. Trimany whitespace off endsGive it a friendly name for the DB Looping nodeBuild IN clausefrom a selection tableCreate 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 String Widget Variable toTable Row Ungroup Cell Splitter Column Rename DB Looping

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!