source table name A A B B B C C D In source table data like this but I want traget table like this name count A 1 A 2 B 1 B 2 B 3 C 1 C 2 D 1 pls any one one solve this........

Rams

• Jul 10th, 2021

Seqfile---Sort----Trans-seqfile
Sort Stage---KeyChange column true
Transfor- in advance tab set mode-Sequence
Create one stage Variable: Stagevar= if KeyChangecol=1 then 1 else Stagevar+1
Create on extracolumn in output give Stagevar=Newcolname

Gabbar

• Dec 8th, 2020

You can solve this problem by using two way 1. using a transformer 2. using aggregator and transformer By using 1st method you can create 2 stage variable i.e Stagevar1 and Stagevar2 In StageVar1 wr...

Answer Question  Select Best Answer