RCP option not available in Pivot stage

ethelvina · Post by **ethelvina** » Mon May 31, 2010 8:50 pm

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

chulett · Post by **chulett** » Mon May 31, 2010 9:17 pm

No. Define the maximum possible and then filter out the empty ones post-pivot.

ray.wurlod · Post by **ray.wurlod** » Mon May 31, 2010 9:28 pm

Have you checked the PXPivot stage? (as opposed to the Pivot stage)

ethelvina · Post by **ethelvina** » Mon May 31, 2010 10:34 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon May 31, 2010 10:41 pm

Are you prepared to use a Server job? It's easy there.

ethelvina · Post by **ethelvina** » Mon May 31, 2010 10:49 pm

No I have to use Parallel job only.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 01, 2010 1:15 am

Why?

Would you use a hammer to fasten a nut and bolt?

ethelvina · Post by **ethelvina** » Tue Jun 01, 2010 2:28 am

Actually my requirement was to do develop a parallel job,how can we implement this using server job?Can you please help me on this?

ray.wurlod · Post by **ray.wurlod** » Tue Jun 01, 2010 2:48 am

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.