row to column

vivek_rs · Post by **vivek_rs** » Tue May 24, 2005 11:52 pm

I have the following requirement...

My Input is:

A1|b1|b2|b3
A2|b4|b5

The Output should be:

A1|b1
A1|b2
A1|b3
A2|b4
A2|b5

Is there a way to do this on the Parallel canvas?

TiA

srekant · Post by **srekant** » Wed May 25, 2005 12:48 am

You can use pivot stage to do it.

vivek_rs · Post by **vivek_rs** » Wed May 25, 2005 2:25 am

There is no Pivot Stage in my Pallette!!???
I am using DataStage 7.1

madhukar · Post by **madhukar** » Wed May 25, 2005 4:03 am

it is a plugin stage

dsxdev · Post by **dsxdev** » Wed May 25, 2005 5:30 am

Hi Vivek
Pivot will do the work this should be there in Parallel Canvas.
You'll find it in in Designer if you right click you'll get Customimze pallette from there you just choose the satge from parallel option.