topic Script load for flat files that have a datestamp in the file name in QlikView https://community.qlik.com/t5/QlikView/Script-load-for-flat-files-that-have-a-datestamp-in-the-file/m-p/228228#M714365 <HTML><HEAD></HEAD><BODY><P>Thanks!!! It worked like a charm</P></BODY></HTML> Thu, 05 Nov 2009 20:10:17 GMT 2009-11-05T20:10:17Z Script load for flat files that have a datestamp in the file name https://community.qlik.com/t5/QlikView/Script-load-for-flat-files-that-have-a-datestamp-in-the-file/m-p/228226#M714363 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>For example the four files below are files that we've recieved on October 2nd, 3rd, 4th, and 5th...</P><BR /><BR /> <P>account_export_20091002.txt<BR />account_export_20091003.txt<BR />account_export_20091004.txt<BR />account_export_20091005.txt</P><P>My question is...</P><P>Can I structure my script to do a loop on the file name, concatenating each file to the all previous files.</P><P>for example</P><P>Load AccountID, Name FROM <A>\\AcountData\account_export_20091002.txt</A></P><P>concanate</P><P>Load AccountID, Name FROM <A>\\AcountData\account_export_20091003.txt</A></P><P>concanate</P><P>and so on, and so on</P><P></P></BODY></HTML> Fri, 30 Oct 2009 03:16:17 GMT https://community.qlik.com/t5/QlikView/Script-load-for-flat-files-that-have-a-datestamp-in-the-file/m-p/228226#M714363 2009-10-30T03:16:17Z Script load for flat files that have a datestamp in the file name https://community.qlik.com/t5/QlikView/Script-load-for-flat-files-that-have-a-datestamp-in-the-file/m-p/228227#M714364 <HTML><HEAD></HEAD><BODY><P>Hi, Can you try:<BR /><BR />Load<BR /> AccountID,<BR /> Name<BR />From <A>\\....\account_Export_*.txt</A>;<BR /><BR />Gabriel</P></BODY></HTML> Fri, 30 Oct 2009 03:49:37 GMT https://community.qlik.com/t5/QlikView/Script-load-for-flat-files-that-have-a-datestamp-in-the-file/m-p/228227#M714364 GabrielAraya 2009-10-30T03:49:37Z Script load for flat files that have a datestamp in the file name https://community.qlik.com/t5/QlikView/Script-load-for-flat-files-that-have-a-datestamp-in-the-file/m-p/228228#M714365 <HTML><HEAD></HEAD><BODY><P>Thanks!!! It worked like a charm</P></BODY></HTML> Thu, 05 Nov 2009 20:10:17 GMT https://community.qlik.com/t5/QlikView/Script-load-for-flat-files-that-have-a-datestamp-in-the-file/m-p/228228#M714365 2009-11-05T20:10:17Z