Pivot Functionality
Moderators: chulett, rschirm, roy
Pivot Functionality
Hello,
Can Pivot be used for an example like below;
Input
Field 1, Field2
p1 u1,u2
p2 u3,u4
Note: Field 2 has multiple values seperated by ','.
Required Output
Field1 Field2
p1 u1
p1 u2
p2 u3
p2 u4
Can Pivot be used for an example like below;
Input
Field 1, Field2
p1 u1,u2
p2 u3,u4
Note: Field 2 has multiple values seperated by ','.
Required Output
Field1 Field2
p1 u1
p1 u2
p2 u3
p2 u4
-
- Participant
- Posts: 9
- Joined: Mon Jun 29, 2009 4:27 pm
-
- Participant
- Posts: 2
- Joined: Thu Nov 20, 2008 6:06 am
- Location: hyderabad
Re: Pivot Functionality
Hi,
Just Make use of stage variable and after that use pivot stage.
Regards
H
Just Make use of stage variable and after that use pivot stage.
Regards
H
-
- Participant
- Posts: 31
- Joined: Wed Mar 17, 2004 3:33 am
Hi ,
Use the Column Import Stage in that Import Input Column=Field2 and in the Output define the columns as Filed3 and Filed4 and in the Output Format Tab final delimeter as 'none' and filed defalts as 'Comma' after that use the pivot stage.
In this method no need to use the Transformer.
Flat File ----->Column Import Stage--- >Pivot Stage--->Flat File.
Regards
Siva
Use the Column Import Stage in that Import Input Column=Field2 and in the Output define the columns as Filed3 and Filed4 and in the Output Format Tab final delimeter as 'none' and filed defalts as 'Comma' after that use the pivot stage.
In this method no need to use the Transformer.
Flat File ----->Column Import Stage--- >Pivot Stage--->Flat File.
Regards
Siva
Shiva,
Field 2 is dynamic. It could have values u1,u2,u3....
Field 2 is dynamic. It could have values u1,u2,u3....
shivakumar wrote:Hi ,
Use the Column Import Stage in that Import Input Column=Field2 and in the Output define the columns as Filed3 and Filed4 and in the Output Format Tab final delimeter as 'none' and filed defalts as 'Comma' after that use the pivot stage.
In this method no need to use the Transformer.
Flat File ----->Column Import Stage--- >Pivot Stage--->Flat File.
Regards
Siva
Craig,
I was trying make it as scalable as possible. Any ways if we define 5 as the upper boundary, I guess the data has to be appended with 3 commas
to the following row inorder to read it. Correct me if I am wrong if you think there is other workaround
Incoming:p1 u1,u2.
Data Modification to read it: p1 u1,u2, , , .
I was trying make it as scalable as possible. Any ways if we define 5 as the upper boundary, I guess the data has to be appended with 3 commas
to the following row inorder to read it. Correct me if I am wrong if you think there is other workaround
Incoming:p1 u1,u2.
Data Modification to read it: p1 u1,u2, , , .
chulett wrote:So you can't even make a reasonable guess as to how many it might have as a maximum? I understand it will vary, that's fine, you're certain there is no effective upper boundary?...
-
- Participant
- Posts: 31
- Joined: Wed Mar 17, 2004 3:33 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: