How to Change Columns into ROWS
Posted: Fri Dec 21, 2007 8:14 am
I have a source file that has 18 columns, 2 of them make Primary Key. I want to convert some of the columns in a row to multiple rows. Example below.
INPUT SOURCE FILE
PKey CustNum Add_1 Tel_1 Zip_1 Add_2 Tel_2 Zip_2 Add_3 Zip_3 Tel_3 Total_Amt Total_Rebate
OUTOUT FILE DESIRED AS
PKey CustNum Add_1 Tel_1 Zip_1 Tot_Amt Tot_Rebate
PKey CustNum Add_2 Tel_2 Zip_2 Tot_Amt Tot_Rebate
PKey CustNum Add_3 Tel_3 Zip_3 Tot_Amt Tot_Rebate
Basically for 3 set of Address Tel and Zip in 1 ROW, I want to create 3 rows that has each set in 1 row?
Any way to get this done in Parallel Job?
INPUT SOURCE FILE
PKey CustNum Add_1 Tel_1 Zip_1 Add_2 Tel_2 Zip_2 Add_3 Zip_3 Tel_3 Total_Amt Total_Rebate
OUTOUT FILE DESIRED AS
PKey CustNum Add_1 Tel_1 Zip_1 Tot_Amt Tot_Rebate
PKey CustNum Add_2 Tel_2 Zip_2 Tot_Amt Tot_Rebate
PKey CustNum Add_3 Tel_3 Zip_3 Tot_Amt Tot_Rebate
Basically for 3 set of Address Tel and Zip in 1 ROW, I want to create 3 rows that has each set in 1 row?
Any way to get this done in Parallel Job?