0 Replies Latest reply: Aug 16, 2011 6:03 AM by Gerhard Laubscher RSS

    concatenate using variable path

    Gerhard Laubscher

      Hi,

       

      Our system generated reports every day, and then sends ot to a folder called "Einstein Reports".

       

      If I open this folder there will be folders for every year, in such a folder will be folders for every month and in such a folder will be folders for every day.

       

      So the last day of June will be        L:\Einstein Folders\2011\062011\30062011

      And the next day will be                 L:\Einstein Folders\2011\072011\01072011

       

      I have one file where I use the following to determine the latest folder to work from and then choose the extract need:

       

      Let LMonth = Date(Today(),'MMYYYY');

      Let LDay = Date(Today()-1,'DDMMYYYY');

       

      Load [1],[2]

       

      From

      [L:\Einstein Reports\2011\$(LMonth)\$(LDay)\Daily_TransactionExtract_*.txt]

       

      This will then replace the file every day.

       

      How can I concatenate these transaction extracts, starting from a specific date? So from the 15th of August (

      L:\Einstein Folders\2011\082011\15082011) I want to Load the Daily_Transaction Extract and then every day after that I want it to concatenate up until the latest file as determined by the variable path.

       

      Any ideas?

       

      Thanks - G