Icon

Dynamic multi -column manipulations

Putting a column expression in a loop Putting a String Manipulation with adynamically created expression in a loop Sample Datarepeatloop from 0 to 2(for 3 columns)Derive outputvalue for new columnusing expression heldin flow variableCreate expressionin flow variableto be usedin actual String Manipulation nodeDefine nameof output columnAllow onlythe new column throughJoin new columnsto original columns by Row IdDefine nameof output columnAllow onlythe new columnthroughSample DataJoin new columnsto original columns by Row Idrepeatloop from 0 to 2(for 3 columns)Derive outputvalue fornew columnusing "dynamically derived"column namesGet Max FK columnReturn 1 or 0depending on whetherat least one FK columnis not missingGet Max FK columnReturn 1 or 0depending on whetherat least one FK columnis not missingtidy uptidy up Table Creator Loop End (ColumnAppend) Counting Loop Start String Manipulation String Manipulation(Variable) String Manipulation(Variable) Column Filter Joiner String Manipulation(Variable) Column Filter Table Creator Joiner Loop End (ColumnAppend) Counting Loop Start Column Expressions Column Aggregator Rule Engine Column Aggregator Rule Engine Column Filter Column Filter Putting a column expression in a loop Putting a String Manipulation with adynamically created expression in a loop Sample Datarepeatloop from 0 to 2(for 3 columns)Derive outputvalue for new columnusing expression heldin flow variableCreate expressionin flow variableto be usedin actual String Manipulation nodeDefine nameof output columnAllow onlythe new column throughJoin new columnsto original columns by Row IdDefine nameof output columnAllow onlythe new columnthroughSample DataJoin new columnsto original columns by Row Idrepeatloop from 0 to 2(for 3 columns)Derive outputvalue fornew columnusing "dynamically derived"column namesGet Max FK columnReturn 1 or 0depending on whetherat least one FK columnis not missingGet Max FK columnReturn 1 or 0depending on whetherat least one FK columnis not missingtidy uptidy upTable Creator Loop End (ColumnAppend) Counting Loop Start String Manipulation String Manipulation(Variable) String Manipulation(Variable) Column Filter Joiner String Manipulation(Variable) Column Filter Table Creator Joiner Loop End (ColumnAppend) Counting Loop Start Column Expressions Column Aggregator Rule Engine Column Aggregator Rule Engine Column Filter Column Filter

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: brian
Created at: 2021-07-23
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.4.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!