Converting rows into columns
Posted: Thu Apr 15, 2010 11:59 pm
Hi
we have the following requirement,
sort code accnt no A B C OccuNo
11 22 5 6 8 1
11 22 8 9 0 2
33 44 6 3 2 1
Output should be like
11 22 5 6 8 8 9 0
33 44 6 3 2 '' '' ''
Can some one helpas how to implemnet it without running the transformer in sequentail. Here the most important part is that the first occur should come first and second later in sequence.
Thank you
we have the following requirement,
sort code accnt no A B C OccuNo
11 22 5 6 8 1
11 22 8 9 0 2
33 44 6 3 2 1
Output should be like
11 22 5 6 8 8 9 0
33 44 6 3 2 '' '' ''
Can some one helpas how to implemnet it without running the transformer in sequentail. Here the most important part is that the first occur should come first and second later in sequence.
Thank you