Page 1 of 1

how we can read single row into multile rows using pivot sta

Posted: Mon Oct 22, 2007 10:13 am
by mallikarjuna36
Friends,

Could you please help me on solving the below problem

I am having a file coming from MV.

the file contains like

"abs,CAA,CGR.." like this,i want to populate the data by
abs
CAA
CGR like this.

I know we can use pivot stage,But my question is where can we give the job parametrers in the pivot stage.And how we can do this.

Thanks for your time and effort.

Thanks,
Arjun

Posted: Mon Oct 22, 2007 10:25 am
by I_Server_Whale
Hi,

You cannot hijack a thread belonging to totally different topic. Please post your question by posting a new topic.

Thanks,
Whale.

Posted: Tue Oct 23, 2007 12:49 pm
by roy
At least I can split it to a new thread :wink:

Posted: Tue Oct 23, 2007 3:21 pm
by ray.wurlod
You don't need any parameters in the Pivot stage. You do, however, need to have parsed the comma-delimited format into separate columns.