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.
Search found 1 match
- 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