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