Merging of flat files based on some value in the file.

[Former Member]

Hi all,

I have one requirment in which I need to pick some flat files(Let say N number of files).

Third row in each file, needs to be read and all files having same value in 3rd row needs to be merged in single file.

There should be as many output files as many different values at row 3rd in all files.

All the files having unique 3rd row value, will be having sequence number in 4th row. While merging we need to take care of the sequence number and need to be merged based on sequence number.

All the files need to be placed at some FTP location

Thanks

Jai

[rajasekhar_reddy14 · Accepted solution]

Hi,

Do file content conversion in Sender side,and use BPM and correaltion.

Regards,

Raj

[Former Member · Accepted solution]

thanks for ur response Raj.

My input files don't have any fixed length or structure.. So It is not possible to write FCC.

Can you please explain your point in detais

My approach is to store the files at some intermediate location and go with two interfaces.

If you have any other idea please let me know.

Thanks

Jai