help needed on rows to column

jeyavel · Post by **jeyavel** » Sat Apr 21, 2007 2:51 pm

I have a file like this

ACCT_NO CUST_ID
0001 aaaa
0001 bbbb
0002 cccc
0002 ddd
0003 fff
0003 eee
0003 ggg
. .
. .
. .
0003 n

I need a output like this.

Acct_no Cust_id
0001 aaaa+bbbb
0002 cccc+ddd
0003 fff+eee+ggg......+n

How to achive this result?.

kcbland · Post by **kcbland** » Sat Apr 21, 2007 3:02 pm

Sort input data by grouping columns, use stage variables in Transformer stage to build result row, output to Aggregator grouping by group-by columns with LAST action on all other columns, output to Sequential file resultant rows.

DSguru2B · Post by **DSguru2B** » Sat Apr 21, 2007 9:17 pm

Or instead of sending to aggregator, load it to hashed file keyed on ACCT_NO. This will automatically retain the last row.