Pivot

[kumar66]

Hi All,


I need to convert the rows to columns.


My input is

H 1
T 1
D 20

My output should be
Head HeaderRC Footer FooterRC Detail DetailRC
H 1 T 1 D 20


Bascially three rows should come into one row.
How to acheive this.?

Please Advice.

Thanks & Regards,
Kumar66

[chulett]

That would be a "vertical pivot".

[Sainath.Srinivasan]

If the target is a sequential file, set the record delimiter to none (or spaces).

[chulett]

That's certainly one technique, which a search would reveal.

[zhzhs]

i think u can do it by transforms stage