Skip to Content
0
Former Member
Nov 14, 2012 at 05:33 PM

Need Help Experts

27 Views

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