RCP option not available in Pivot stage
Moderators: chulett, rschirm, roy
RCP option not available in Pivot stage
RCP option is not available in pivot stage and I am not sure of the no of columns I have to pivot, In pivot stage I had passed the column names(the one I am going to pivot) as parameters, but as RCP is not available for pivot, I get the error as could not find the input column to pivot,when I define the metadata in pivot stage the job is working fine.Is there any way to pivot(horizontal) the columns dynamically.Please help
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ya I have checked the PXPivot stage,even this stage is not having RCP option.
My requirement is like
e.g.
Key_A Col_A Col_B...................Col_N
100 fgh abc...................... xyz
Then I should get the output as
Key_A ColumnNames ColumnValues
100 Col_A fgh
100 Col_B abc
.....
.....
.....
100 Col_N xyz
Here I am not sure how many no of columns I will have,Is there any way to implement this without using pivot stage.
My requirement is like
e.g.
Key_A Col_A Col_B...................Col_N
100 fgh abc...................... xyz
Then I should get the output as
Key_A ColumnNames ColumnValues
100 Col_A fgh
100 Col_B abc
.....
.....
.....
100 Col_N xyz
Here I am not sure how many no of columns I will have,Is there any way to implement this without using pivot stage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Accumulate the non-key columns into a value mark (@VM) delimited string and write to a hashed file where that is keyed by the grouping key and that column is defined as multi-valued in the metadata. Then read from the hashed file normalizing on the multi-valued field.
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.