concatenate the name field & remove duplicate id

[rohit19 k]

we have a sequential file in which there are two columns i.e. id & name
Id name
10 a
10 b
20 c
20 d

I want a output in following format:

id name
10 ab
20 cd

concatenate the name field & remove duplicate id using stage variable in Transformer.

[chulett]

Moderator - please move to the PX forum.