Hello Experts,
I have the flat file as my source and records are coming like this.
----------------------------------------------------------------------------------------------------------------------------------------------
TERM TERMINAL ADDRESS TYPE
ID COUNT US COUNT COUNT %
------------------------------------------------------------------------------------------------------------------------------------------------
1111 199 michigan ave , SANTACLARA FINANCIAL 111 125 600 22.66%
NON-FINANCIAL 222 126 700 23.68%
SURCHARGE 333 127 800 24.00%
My Question is how do I repeat the column1 and Column2 get repeated for row 2 and row3.
Thanks,
Nis