rows to column

[shwetha.st]

Hi all

I rows something like this A B C D and i want it like
A
B
C
D

iam trying to use a pivot but i am getting the output same as that of the input.
I am not able to see any options in Pivot so that i can change.
It is having just the STAGE,INPUT and OUTPUT.Where can i set the things which will work can anyone help me out.

Thanks in advance

[ray.wurlod]

Read the manual for the Pivot stage (pivot.pdf).
You may need to create an artificial pivot key column upstream of the Pivot stage, and discard it afterwards.

[chulett]

Columns to rows, actually. As an alternative, check this post.

[baglasumit21]

Hi all

I rows something like this A B C D and i want it like
A
B
C
D

iam trying to use a pivot but i am getting the output same as that of the input.
I am not able to see any options in Pivot so that i can change.
It is having just the STAGE,INPUT and OUTPUT.Where can i set the things which will work can anyone help me out.

Thanks in advance

Try This using stage variable if u r writing a file
stage Derivation
variable
name

stg1 inputlink (say A B C D)
stg2 char(10)


now outputlink.colname derivation will be

ereplace(stg1," " , stg2)

[rafik2k]

Hi all

I rows something like this A B C D and i want it like
A
B
C
D

iam trying to use a pivot but i am getting the output same as that of the input.
I am not able to see any options in Pivot so that i can change.
It is having just the STAGE,INPUT and OUTPUT.Where can i set the things which will work can anyone help me out.

Thanks in advance

Try This using stage variable if u r writing a file
stage Derivation
variable
name

stg1 inputlink (say A B C D)
stg2 char(10)


now outputlink.colname derivation will be

ereplace(stg1," " , stg2)

Have you tested your logic?
This will work perfectly if source column1 ="A B C D", that is for a single string.

But here Data shows there are four columns, so in this case it won't work.
U have to duplicate this logic for every input column.