Icon

row_​comparison

row comparison

There has been no description set for this workflow's metadata.

sampledataNode 2write totemporary DBappendrowIndexloop overrowsget unclearedrowsskip!skip!Flow Variablecontrolled(mirrors Loop Start)limit to1st rowinsertcurrent rowset Clearedto "Yes"Node 22Node 23Node 24loop endrowsget resultsfree()rowIndexASCremoveclutterNode 30Node 31sampledataappendrowIndexloop overrowssplit off1st row1st rowto Flow Variabletop: matchbottom: no matchlimit to1st rowcollectunwanted rowscurrent row+1st matching rowNode 41set Clearedto "Yes"loop endrowsrowIndexASCrowIndexASCNode 48removeclutterExcel Reader H2 Connector DB Writer Math Formula Table Row ToVariable Loop Start DB Query Reader Empty Table Switch Empty Table Switch Variable toTable Row Row Filter Concatenate Rule Engine DB Update End IF End IF Variable Loop End DB Query Reader DB ConnectionCloser Sorter Column Filter RowID check cases Excel Reader Math Formula RecursiveLoop Start Row Splitter Table Rowto Variable check cases Row Splitter Concatenate Concatenate Extract TableDimension Rule Engine Recursive Loop End Sorter Sorter RowID Column Filter sampledataNode 2write totemporary DBappendrowIndexloop overrowsget unclearedrowsskip!skip!Flow Variablecontrolled(mirrors Loop Start)limit to1st rowinsertcurrent rowset Clearedto "Yes"Node 22Node 23Node 24loop endrowsget resultsfree()rowIndexASCremoveclutterNode 30Node 31sampledataappendrowIndexloop overrowssplit off1st row1st rowto Flow Variabletop: matchbottom: no matchlimit to1st rowcollectunwanted rowscurrent row+1st matching rowNode 41set Clearedto "Yes"loop endrowsrowIndexASCrowIndexASCNode 48removeclutterExcel Reader H2 Connector DB Writer Math Formula Table Row ToVariable Loop Start DB Query Reader Empty Table Switch Empty Table Switch Variable toTable Row Row Filter Concatenate Rule Engine DB Update End IF End IF Variable Loop End DB Query Reader DB ConnectionCloser Sorter Column Filter RowID check cases Excel Reader Math Formula RecursiveLoop Start Row Splitter Table Rowto Variable check cases Row Splitter Concatenate Concatenate Extract TableDimension Rule Engine Recursive Loop End Sorter Sorter RowID 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: JohannesHolzschuh
Created at: 2022-03-31
On NodePit since: 2022-04-18
Last update: 2024-04-28
Created with KNIME version: v4.5.2

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

Try NodePit Runner!