[resolved] How to add sequence/running number of duplicate data
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
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