Script load for flat files that have a datestamp in the file name

[#1]

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...

account_export_20091002.txt
account_export_20091003.txt
account_export_20091004.txt
account_export_20091005.txt

My question is...

Can I structure my script to do a loop on the file name, concatenating each file to the all previous files.

for example

Load AccountID, Name FROM \\AcountData\account_export_20091002.txt

concanate

Load AccountID, Name FROM \\AcountData\account_export_20091003.txt

concanate

and so on, and so on

[GabrielAraya · Accepted solution]

Hi, Can you try:

Load
AccountID,
Name
From \\....\account_Export_*.txt;

Gabriel

[#3]

Thanks!!! It worked like a charm