when lookup returns multiple rows - accomidate in same row
Posted: Fri Jun 22, 2007 7:38 am
my requirement is as follows, i have an input file, and on one of the fields , i need to do a look up, which will return 3 rows always, with 1 column ineach row, now i need to add these 3 vaules from 3 rows into an output file into 3 diff column on the same row. we are using lookup stage in parallel, but dont know how to proceed further.
ex : input file
123,234,2345
look up on 234 returns 12
13
14
output should be:
123,234,2345,12,13,14
appreciate any help
ex : input file
123,234,2345
look up on 234 returns 12
13
14
output should be:
123,234,2345,12,13,14
appreciate any help