Pivoting Data

mallikarjuna36 · Post by **mallikarjuna36** » Mon Oct 22, 2007 10:13 am

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

I_Server_Whale · Post by **I_Server_Whale** » Mon Oct 22, 2007 10:25 am

Hi,

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

Thanks,
Whale.

roy · Post by **roy** » Tue Oct 23, 2007 12:49 pm

At least I can split it to a new thread

ray.wurlod · Post by **ray.wurlod** » Tue Oct 23, 2007 3:21 pm

You don't need any parameters in the Pivot stage. You do, however, need to have parsed the comma-delimited format into separate columns.

DSXchange

Pivoting Data

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