How to convert multiple columns into rows.

sirishds · Post by **sirishds** » Mon Jun 21, 2010 5:20 am

Hi,

Please find the requirement below For better understanding about my query i have underline the required output

source Target
custno custpre abc
1 2 1,2,3
1 3 2,5,6
2 5
3 6

How do i perform if using transformer.

Thanks in advance
Regards,
Sirish.

ArndW · Post by **ArndW** » Mon Jun 21, 2010 5:31 am

Please look into the Pivot Enterprise stage in the Parallel Job Developer Guide and, should your needs not be met by that stage, ask again here in this thread.

sirishds · Post by **sirishds** » Mon Jun 21, 2010 5:36 am

ArndW wrote:Please look into the Pivot Enterprise stage in the Parallel Job Developer Guide and, should your needs not be met by that stage, ask again here in this thread.

Thanks for your prompt reply ANDRW but i could not meet my requirement by pivot stage i initiated my job initially by Pivot stage,i am supposed to use transformer folowed by aggregator to perform the job

thanks in advance.
Sirishds

ray.wurlod · Post by **ray.wurlod** » Mon Jun 21, 2010 5:41 am

Why?

Would you use a hammer to tighten a screw?

Use the right tool for the job.

Resist stupid requirements!

ArndW · Post by **ArndW** » Mon Jun 21, 2010 6:01 am

It can be done using stage variables, but I agree with Ray that unless there is a good reason not to use the pivot it should be used.