Albany and KKB both come out of the same file. I need to filter the raw data in file Heidelberg KKB 090620-091220. In column C I select only chain 5050000. That is the data for albany.
To get the kkb data I need to deselect 5050000 and that is the kkb data.










Client Data Store Location File Name Patteren File Type
Flexibake C:\Data\Flexibake HEIDELBERG-INVCR & ddmmyy csv
Albany C:\Data\Albany Heidelberg KKB ddmmyy-ddmmyy ?
midstate C:\Data\midstate DateFormat("mm.dd.yy") & _Recap xlsx
ahold C:\Data\ahold 13 digit numer & _ & 11 digits number csv
kkb C:\Data\kkb ? ?
Client Data Store Location File Name Patteren File Type
Flexibake C:\Data\Flexibake HEIDELBERG-INVCR092220 csv
Albany C:\Data\Albany Heidelberg KKB 090620-091220 csv
midstate C:\Data\midstate 08.15.20_Recap xls
ahold C:\Data\ahold 0056919000647_0004353672 csv
kkb C:\Data\kkb Heidelberg KKB 090620-091220 csv
vbc C:\Data\vbc VBC HB090620-091220 xlsx


I created the structure like you recommended. The above is the new tree created.
The flexibake raw data is the only one that I need to edit the credit identification numbers as explained in this thread.