Left Join - multiple files with timestamps in file name
I need to expand the following script to incorporate multiple files which I receive daily. Note that the daily files has Account ID's in it which I want to filter out by doing a Left Join.
LOAD Account_ID, Client FROM [Data.xls](....);
Left Join LOAD Account_ID, '31/03/2010' as Date FROM [CRM\Value_20100331.txt](...);
To load the daily files, I changed the last line of script to: FROM [CRM\Value_*.txt](...);
1. How do I assign the timestamp in the file name to [Date] 2. How do I change the code to ensure that the Left Join function keeps applying with the first file and not continously on eachother as I add daily CRM files?