concatenate the name field & remove duplicate id
Posted: Thu Jun 04, 2009 4:32 am
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.
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.