How to get related data in Group By

[mlauber71]

The idea would be to keep a RowID or artificial ID together with the New ID and then join back all lines that are associated with it.

We had a similar discussion involving duplicates where instead of removing them one could keep the latest one:

Remove rows with duplicate values

I set up a workflow to demonstrate how this could be done use group by to calculate how many duplicates there are (note: KNIME should introduce a generic COUNT(*) function - I had to use a variable) if the count is larger then 1 it is a duplicate left join it back to the original data sort the data by ID and other variables if you want to keep one of the duplicates use the LAG column to identify which line is a 2nd, 3rd occurrence of a duplicate make a rule to keep just a single line of each …