A,B,C ---> a b c
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
A,B,C ---> a b c
Hi ,
I have acolumn where the value is A,B,C and I want this value to be going into 3 columns
A
B
C
How do I do it, tried to look into Sting functions like Field, SubStr but of no use.
Any help is appreciated .
Thanks,
I have acolumn where the value is A,B,C and I want this value to be going into 3 columns
A
B
C
How do I do it, tried to look into Sting functions like Field, SubStr but of no use.
Any help is appreciated .
Thanks,
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
amsh76 wrote:Wait a sec...do you mean three rows ???? and not columns
If thats the case then look at Pivot Stage....
Sorry, if I misinterpreted your question.
Pivot stage cannot be used for rows to columns conversion, pivot will help you transform the other way i.e., columns to rows.
Shantanu Choudhary
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Assuming that there would be another KEY column along with the column you have mentioned in your example, I would suggest you to refer the below link/post:
viewtopic.php?p=123634&highlight=#123634
viewtopic.php?p=123634&highlight=#123634
Shantanu Choudhary
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you want N comma-delimited values into N separate columns in one row (the OP specification used the word "columns"), the output side of a Transformer stage must have Max(N) columns defined, and the Field function used to separate into separate columns.
This design should also be used if N separate rows each with one column are required. The Transformer stage is still used to separate the data into separate columns, then this output is fed into a Pivot stage. The non-matched columns in the Transformer stage output should be set to NULL.
This design should also be used if N separate rows each with one column are required. The Transformer stage is still used to separate the data into separate columns, then this output is fed into a Pivot stage. The non-matched columns in the Transformer stage output should be set to NULL.
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.