Converting rows into columns

[divine]

Hi,

I have got a sequential file having 10 records into it. I want to transpose the recordset. How it can be done. For eg I ve got the following records at the input -
1 AA
2 BB
3 CC

The output should be -
1 2 3
AA BB CC

Please let me know how it can be done.
Thanks in advance,
Arindam.

[ray.wurlod]

Search for "vertical pivot", for it is that which you are striving to accomplish.

[abhishekachrekar]

Hi Ray,

Can we use vertical pivot when we dont know the number of rows?

Eg
My file contains

1 AA
2 BB
3 CC
.
.
.
<N> LMT
Where <N> is any integer value.

Actually my requirement is as follows.
My file contains following recs.

A1 1
A2 2
A3 3
A4 4
A5 5

Now I have to generate following recs in addition to the above recs.
B1 A1(value)/A3(value)
B2 A2(value)/A4(value)

now A1(value) is the col2 value corresponding to A1 in the input file.
Since it is difficult to do calculations on data in different rows, I thought of transposing the rows to columns. But since the number of rows are not known I find it difficult to transpose it.

Kindly advise if there is any other way to achieve the result.

Regards,
Abhishek

[ray.wurlod]

This is very easy to do in a server job. Are you prepared to go that route?

Write into a hashed file or UniVerse table normalized on a multi-valued field then read it back un-normalized, converting the value marks (@VM) to whatever delimiter you require.