Changing the Data format - Columns to Rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Tue Jan 29, 2008 6:03 am
- Location: Guntur
- Contact:
Changing the Data format - Columns to Rows
Hi,
I have data like the following:
Col1 ColA ColB ColC ColA1 ColB1 ColC1
--------------------------------------------------------------
123 abc def ghi jkl mno pqr
456 stu vwx yza bcd efg hij
My requirement is that I need the data in the following format:
Col1 ColA ColB ColC
------------------------------
123 abc def ghi
123 jkl mno pqr
456 stu vwx yza
456 bcd efg hij
Could anyone please let me know which stage i need to use and a bit of insight into the logic..
Thanks.
I have data like the following:
Col1 ColA ColB ColC ColA1 ColB1 ColC1
--------------------------------------------------------------
123 abc def ghi jkl mno pqr
456 stu vwx yza bcd efg hij
My requirement is that I need the data in the following format:
Col1 ColA ColB ColC
------------------------------
123 abc def ghi
123 jkl mno pqr
456 stu vwx yza
456 bcd efg hij
Could anyone please let me know which stage i need to use and a bit of insight into the logic..
Thanks.
Samratisking
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Transformer stage with two outputs followed by a Funnel stage. The key goes to both output links. The first three columns go to the first output link, the other three columns go to the second output link.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 37
- Joined: Tue Jan 29, 2008 6:03 am
- Location: Guntur
- Contact:
Hi Ray,ray.wurlod wrote:Transformer stage with two outputs followed by a Funnel stage. The key goes to both output links. The first three columns go to the first output link, the other three columns go to the second output ...
That's a cool way of doing it. Instead, you think I can use a Copy stage and Funnel stage to funnel the data into single output..? Is there any particular need to use the Transformer here?
Thanks.
Samratisking
-
- Participant
- Posts: 59
- Joined: Wed Dec 31, 2008 5:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 37
- Joined: Tue Jan 29, 2008 6:03 am
- Location: Guntur
- Contact:
-
- Participant
- Posts: 37
- Joined: Tue Jan 29, 2008 6:03 am
- Location: Guntur
- Contact:
-
- Participant
- Posts: 37
- Joined: Tue Jan 29, 2008 6:03 am
- Location: Guntur
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: