I am trying to restructure my input table. In another word the table's input columns will be the table's output rows.
Suppose I have the following INPUT table:
col1 col2 col3
==== ===== =====
1 STEVE 10.00
4 RON 15
and would like to restructure that INPUT table to the following OUTPUT table;
col_name value
======== =======
col1 1
col2 STEVE
col3 10.00
col1 4
col2 RON
col3 15
What type of existing operator/stage will do the trick. I am trying to avoid custom coding for this.
There are operators listed under "The restructure library" such as field_export, field_import, makevect, splitvect and etc. I have not worked with these operators. Can someone who used them in the past, give me the right direction.
Note: I am not dealing with COBOL or any Mainframe stuff
How do I Restructre a Table
Moderators: chulett, rschirm, roy
How do I Restructre a Table
iShoreETL