Page 1 of 1

How to convert multiple columns into rows.

Posted: Mon Jun 21, 2010 5:20 am
by sirishds
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.

Posted: Mon Jun 21, 2010 5:31 am
by ArndW
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.

Posted: Mon Jun 21, 2010 5:36 am
by sirishds
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

Posted: Mon Jun 21, 2010 5:41 am
by ray.wurlod
Why?

Would you use a hammer to tighten a screw?

Use the right tool for the job.

Resist stupid requirements!

Posted: Mon Jun 21, 2010 6:01 am
by ArndW
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.