Skip to Content
0
Former Member
May 07, 2008 at 06:40 AM

RFC to File scenario Concatenate and sort files

26 Views

Hi,

I have an RFC->File Scenario where I am supposed to pick the multiple flat files ABC<MsgGUID>.txt from a directory on the FTP server and concatenate the multiple flat files into a single one and sort the flat file based on the some key fields as key.

If the file has multiple lines with same values for the key fields then i am suppposed to write only a single line by discarding duplicate lines with the same key and the field quantity has to be summed up.

How can I go about this kindly help me

Thank you,