2 Replies Latest reply: Nov 5, 2009 3:10 PM by jmorales2 RSS

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

      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