DSXchange

Posted: **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

Posted: **Wed May 25, 2005 12:48 am**

You can use pivot stage to do it.

Posted: **Wed May 25, 2005 2:25 am**

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

Posted: **Wed May 25, 2005 4:03 am**

it is a plugin stage

Posted: **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.

DSXchange

row to column

row to column