Correlation sets
I have a folder that contains a bunch of flat files. For example AAA_001.DAT, AAA_002.DAT thru AAA_004.Dat, then next set ABC_001.DAT, ABC_002.DAT thru ABS_004.Dat, BBC_001.Dat etc etc. I have four receive locations(one for 001.dat thru 004.dat as they have different schema definitions). I want to be able to correlate on the file name first three letters only. For example, AAA, and ABC, BBC, etc. What is the best way to do this?
|