horizontal pivoting using transformer
Posted: Mon Apr 07, 2014 4:01 am
Hi All,
Needed a logic in transformer for the below scenario. i shouldn't use pivot stage. and needed in datastage and not using unix.
I/P data:
Account_numb Name Total
123 ABCDEF 123456789
345 GHIJKLMN 987654321
O/P data:
Account_numb Name Total
123 AB 123
123 CD 456
123 EF 789
345 GH 987
345 IJ 654
345 KL 321
345 MN NULL
Thanks in Advance,
Needed a logic in transformer for the below scenario. i shouldn't use pivot stage. and needed in datastage and not using unix.
I/P data:
Account_numb Name Total
123 ABCDEF 123456789
345 GHIJKLMN 987654321
O/P data:
Account_numb Name Total
123 AB 123
123 CD 456
123 EF 789
345 GH 987
345 IJ 654
345 KL 321
345 MN NULL
Thanks in Advance,