Hi All,
I have the below scenario and my pinput data is as below
Input
-----
Id, Name
1, r;b;c
2 a;d;g;h;j
Name field has data which is ';' delimited but it is one record
I would like my input to be as shown below:
Output
------
Id, Name
1,r
1,b
1,c
2,a
2,d
2,g
2,h
2,j
Any help here please.
Thanks
Cherry
convert column data in to rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Cherry,
This may be possible through loop variable in transformer stage.
1.In stage variable-
Name SV1
2. In loop variable-
Loop condition-
3.In derivation map the ID directly from input and the take the output of LV1 for Name.
Please let me know if I am wrong.
This may be possible through loop variable in transformer stage.
1.In stage variable-
Name SV1
2. In loop variable-
Loop condition-
Code: Select all
@iteration<=DCount(SV1,";")
Code: Select all
Field(SV1,";",@iteration) LV1
Please let me know if I am wrong.