Hi, I have a data set in KNIME that looks like this (columns and rows): ID - Prod1 - Prod2 - Prod3 - Prod4 - Prod5 1 - 23 - 24 - 25 - 26 - 27 2 - 23 - 24 - 25 - 26 - 26 As you can see there is a duplicate on the second row (26 and 26) but the first row only contain unique values. I would now like to classify each row based on if all the column values for each row are unique or not, with this ideal output: ID - Prod1 - Prod2 - Prod3 - Prod4 - Prod5 - UniqueFlag 1 - 23 - 24 - 25 - 26 - 27 - Unique 2 - 23 - 24 - 25 - 26 - 26 - Not unique What would be the best way to set this up? Thanks for your help.

Hi, This is what I can suggest: [unique] Use a “Column Aggregator” node and choose all the columns that you want to check and in the option tab choose “Set” as the aggregation method. Then a “Column Expressions” node and use this expression: if (column("Set").length < 5){ "Not Unique" } else "Unique" I used 5 because in your example you have 5 prod columns but you can change the number. Output: [unique1] Best, Armin [solution]

Finding duplicate values in columns per row

KNIME Analytics Platform

cason January 26, 2019, 11:23am 6

Hi @armingrudd,

Thanks for this. I have created a new topic here:

1 Like