How to get the unique dates against in a column against a unique ID

Omprakash_Jena · October 16, 2019, 10:17am

I have a unique ID column and a date column. I have to get unique dates against each unique ID. Please help me.

tommy · October 16, 2019, 10:22am

GroupBy Node with your 2 columns ID, date as “Group columns”.

ipazin · October 16, 2019, 3:20pm

welcome to KNIME Community!

Now there is a dedicated node for de-duplication - Duplicate Row Filter node.

If you wish to have unique ID with all unique dates in one row use GroupBy node where grouping column is ID column and aggregation method Unique concatenate on your date column.

Br,
Ivan

Omprakash_Jena · October 21, 2019, 8:40pm

Thank you so much for the help!

system · April 21, 2020, 8:40am

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.