topic Re: How to assign same number to duplicate values in a column in Talend Studio

How to assign same number to duplicate values in a column

Anonymous — Sat, 16 Nov 2024 04:31:06 GMT

Hi, consider the data given below

Bill

Clive

Mary

John

Lily

How do i assign same number to the duplicates so that the output looks like this;

1 Bill

2 Clive

3 Mary

4 John

5 Lily

Re: How to assign same number to duplicate values in a column

TRF — Tue, 01 Oct 2019 09:36:16 GMT

Have a look to tAggregateRow

Re: How to assign same number to duplicate values in a column

manodwhb — Tue, 01 Oct 2019 09:40:58 GMT

@ahmed_analytics ,check the below solution.

Re: How to assign same number to duplicate values in a column

Anonymous — Tue, 01 Oct 2019 09:42:44 GMT

can you please elaborate on how to use taggregate row

Re: How to assign same number to duplicate values in a column

Anonymous — Tue, 01 Oct 2019 09:45:07 GMT

What if the duplicates are not in order ?

example:

Bill

Clive

Bill

Mary

Bill

Clive

Mary

then it still should be

1 Bill

2 Clive

1 Bill

3 Mary

1 Bill

2 Clive

3 Mary

Re: How to assign same number to duplicate values in a column

manodwhb — Tue, 01 Oct 2019 09:48:54 GMT

@ahmed_analytics ;check the below one.

Re: How to assign same number to duplicate values in a column

TRF — Tue, 01 Oct 2019 10:06:08 GMT

@ahmed_analytics, forget tAggregateRow in this case

Re: How to assign same number to duplicate values in a column

Anonymous — Wed, 02 Oct 2019 05:48:37 GMT

Thanks @manodwhb , sorting the rows first did the trick.