Split duplicate lines by 1st,2nd 3rd etc..

[erisu]

Hi KNIME expert

May I ask how to build workflow for the following?
Any help would be appreciated.

I would like to add 1st , 2nd ,3rd etc for duplicate columns.

E.g

Customer	Delivery date
A	Nov1	1
A	Nov2	1
A	Nov1	2
B	Nov2	1
B	Nov2	2

And split data to avoid duplicate

↓

Customer	Delivery date
A	Nov1	1
A	Nov2	1
B	Nov2	1

Customer	Delivery date
A	Nov1	2
B	Nov2	2

[izaychik63]

Take a look at

Rank — NodePit

node

[ipazin]

Hello @erisu,

but what do you mean with split data? Do you need to process them differently? How many duplicates can you have for one customer for same date?

Br,
Ivan

[Daniel_Weikert]

If you want to filter or mark the duplicates => duplicate row filter
If you want to know how often duplicates for one customer appear => Groupby

[Mark_Ortmann]

The duplicate row filter can be configured (advanced tab) so that it marks your entries https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.duplicates.DuplicateRowFilterNodeFactory
Afterwards you can e.g. use row filter or splitter nodes to create the desired tables.

Best
Mark

[erisu]

Yes I need to both data but in separate files. Thank you for your help!