Convert Pivot to Flat file

[vskr72]

I have a file in this format.

.........P1 P2 P3............................
A001 v11 v21 v31.......................
A002 v12 v22 v32.......................
A003 v13 v23 v33.......................
A004 v14 v24 v34.......................
.................................................
.................................................
.................................................
A00n

This has to be flattened in this format

A001 P1 v11
A001 P2 v21
A001 P3 v31
A001 P4 v41
...
...
...

Please let me know if there is a good way to do it in Datastage (Server Ed.) or should I use AWK to do it?

Kumar

[ray.wurlod]

This is what's called a horizontal pivot and is exactly what the Pivot stage is intended to do.
Look in your manuals for Pivot.pdf which explains how to use it, with examples.
Search the forum for an example of pivoting the constants (P1 through P4).