Code: Select all
Input
ColA
1
2
3
4
5
Output
ColA
(1,2,3,4,5)
there is no common key in the input 5 records.Since there is no common key,I think like we cannot use lastrowingroup() function in transformer. I tried like this but i didnt get the ouput
i have designed the job like below
seqfile---sortstage--transformer-output
in transformer i created stage variable like below
svtemp: if (keychangecolumn=1) then svtemp:",":COLA else COLA
thanks
Rakesh