Icon

Exercise3

Chapter 6 / Exercise 3
Workflow: Chapter6/Exercise3 In this exercise, we clean up a file from duplicates.The easiest way would be to use a GroupBy node, group by contract IDs and take onlythe first item in the group.A more complex way would be using a group loop.But we choose the most complex way of all, through a TableRow to Variable Loop Startjust to show how the TableRow to Variable Loop works. Note. Since KNIME has been thought in terms of datatable, loops are rarely needed. Before using aloop make sure that a dedicated node for whatyou have in mind does not exist! list of "contract nr"start loop on "contract nr"one by onefilter by "contract nr"only 1st rowmost recent load_dateto remove duplicatesNode 36sort ascending on load_datecontract nr are not uniqueRowID on contract nrfailsnow check againuniqueness on"contract nr"keep only "contract nr"Wrong sales file with duplicated contract number. One row is missing the "amount" and "quantity" values.remove duplicates bygrouping on contract nrand using First for aggregationNode 56GroupBy Table Row ToVariable Loop Start Row Filter Row Filter Loop End Sorter RowID RowID Column Filter File Reader GroupBy String to Date&Time Workflow: Chapter6/Exercise3 In this exercise, we clean up a file from duplicates.The easiest way would be to use a GroupBy node, group by contract IDs and take onlythe first item in the group.A more complex way would be using a group loop.But we choose the most complex way of all, through a TableRow to Variable Loop Startjust to show how the TableRow to Variable Loop works. Note. Since KNIME has been thought in terms of datatable, loops are rarely needed. Before using aloop make sure that a dedicated node for whatyou have in mind does not exist! list of "contract nr"start loop on "contract nr"one by onefilter by "contract nr"only 1st rowmost recent load_dateto remove duplicatesNode 36sort ascending on load_datecontract nr are not uniqueRowID on contract nrfailsnow check againuniqueness on"contract nr"keep only "contract nr"Wrong sales file with duplicated contract number. One row is missing the "amount" and "quantity" values.remove duplicates bygrouping on contract nrand using First for aggregationNode 56GroupBy Table Row ToVariable Loop Start Row Filter Row Filter Loop End Sorter RowID RowID Column Filter File Reader GroupBy String to Date&Time

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2020-05-26
Last update: 2024-04-24
Created with KNIME version: v4.0.0
Tags: BooksKNIME Advanced Luckexerciseloopflow control

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

Try NodePit Runner!