DSXchange

HI, thanks for the reply. COuld u explain a bit codewise, so that I can understand better whta u mean. Im new to DS.

Thanks

Hi DSperts, I have an input file of three columns in the ffg format ID ControlNO Amount 0000 Y345 7 0000 Y346 5 0001 Y322 4 0001 Y341 6 0002 Y345 6 0002 Y234 2 I want this transformed to have this format since ID is repeated I dont repeat it in the next col. I want the target file to look like this ...