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

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

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


Hi there @Omprakash_Jena,

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.


1 Like

Thank you so much for the help!

1 Like

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