This content has been marked as final. Show 2 replies
I'm recieving files from a vendor that I store on my QV server. The vendor is sending a daily file whose filename is trailed by a date stamp.
For example the four files below are files that we've recieved on October 2nd, 3rd, 4th, and 5th...
My question is...
Can I structure my script to do a loop on the file name, concatenating each file to the all previous files.
Load AccountID, Name FROM \\AcountData\account_export_20091002.txt
Load AccountID, Name FROM \\AcountData\account_export_20091003.txt
and so on, and so on