topic Re: [resolved] How to add sequence/running number of duplicate data in Talend Studio

[resolved] How to add sequence/running number of duplicate data

_AnonymousUser — Fri, 28 Sep 2012 04:34:34 GMT

Hi,
i have problem with duplicate data but there'a a way to avoid this duplicated. by add new sequence data for each data.
example :
Name
AA
AA
AA
BB
CC
DD
DD
i need.
Name | SubName
AA | 1
AA | 2
AA | 3
BB | 1
CC | 1
DD | 1
DD | 2
i have tFileInputExcel (1 column) -> ?? -> tFileOutputExcel (2 columns)
How could i proceed? Please help.
Thanks,
Rebacca.

Re: [resolved] How to add sequence/running number of duplicate data

Anonymous — Fri, 28 Sep 2012 07:08:24 GMT

Hi
You can use Numeric.sequence("s1",1,1) to generate a sequence number for each item on tMap. see my screenshots.

Re: [resolved] How to add sequence/running number of duplicate data

_AnonymousUser — Fri, 28 Sep 2012 07:28:50 GMT

Hi,
I Hope your requirement is to remove the Duplicate data in the Input Excel File.
Then you may simply use the component tUniqRow.
The Screenshot follows.

Re: [resolved] How to add sequence/running number of duplicate data

_AnonymousUser — Fri, 28 Sep 2012 09:01:48 GMT

i'm using tMap and Numeric.sequence. it works.
Big thanks.

Re: [resolved] How to add sequence/running number of duplicate data

_AnonymousUser — Thu, 26 Feb 2015 07:07:12 GMT

i have used that tmap and Numeric.sequence("s",1,1) and iam getting
aa 1
aa 2
aa 3
bb 4
bb 5
cc6
so i want output as
aa 1
aa 2
aa 3
bb 1
bb 2
cc 1
how does it is possible? world you please help in this regard? @shong

Re: [resolved] How to add sequence/running number of duplicate data

Anonymous — Wed, 02 Sep 2015 12:47:31 GMT

Try this in tMap new field:
Numeric.sequence(row1.Name,1,1)

Re: [resolved] How to add sequence/running number of duplicate data

Muhammad_irtiza — Wed, 03 Mar 2021 05:55:16 GMT

@Ilya V I Have tried this but it will give me the below result:

A 1

A 2

B 1

C 1

B 2

how can I achieve the below result:

A 1

B 2

C 3

B 2