Search found 1 match

by rohit19 k
Thu Jun 04, 2009 4:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: concatenate the name field & remove duplicate id
Replies: 1
Views: 895

concatenate the name field & remove duplicate id

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.