Icon

KNIME_​compare_​rows 1

Initial data setup Find all rows with a matching -ve non-zero amt_diff and create column "Observation" Produce the required output by joinging back to the original data usingRow number as the key Sample DataGenerate arow numberfor ease ofsorting andjoiningRename "counter"as "Row"put "Row" atcolumn 1Get negative_diffas amt_diff * -1Join all non-zero rowsto all others whereby row A's negative_diff= row B's amt_diff Get rows withnon-zero amt_diffJoin all those "Swing" rowsback to original rowsby joining on Row numberPut back in originalrow orderAll the matching rowsneed to have "Swing"as observationFill in missing"Observation"sas blank Table Creator Counter Generation Column Rename Column Resorter Math Formula Joiner Row Filter Joiner Sorter Rule Engine Missing Value Initial data setup Find all rows with a matching -ve non-zero amt_diff and create column "Observation" Produce the required output by joinging back to the original data usingRow number as the key Sample DataGenerate arow numberfor ease ofsorting andjoiningRename "counter"as "Row"put "Row" atcolumn 1Get negative_diffas amt_diff * -1Join all non-zero rowsto all others whereby row A's negative_diff= row B's amt_diff Get rows withnon-zero amt_diffJoin all those "Swing" rowsback to original rowsby joining on Row numberPut back in originalrow orderAll the matching rowsneed to have "Swing"as observationFill in missing"Observation"sas blankTable Creator Counter Generation Column Rename Column Resorter Math Formula Joiner Row Filter Joiner Sorter Rule Engine Missing Value

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: @takbb Brian Bates
Created at: 2021-05-03
On NodePit since: 2022-02-06
Last update: 2024-04-28
Created with KNIME version: v4.3.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!