DSXchange

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

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

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

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.

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

No I have to use Parallel job only.

Why?

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

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?

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.