3 Replies Latest reply: May 31, 2011 7:58 AM by Gerhard Laubscher RSS

    Load from multiple daily extracts

    Gerhard Laubscher

      Hi,

       

      I am loading (concatenating) the same daily application extract into QV every single day. At the moment I copy and paste the entire load script for the extract, then I simply put the name of the new day’s extract in the FROM statement. This means my script is increasing in size exponentially every day.

       

      Is there any way to just load the same fields and then type in the name of all the extracts in the FROM statement?

       

      For instance:

       

      Load Field1

                 Field1

                 Etc.

      FROM Extract_Day_1

       

      Concatenate Load Field1

      Field1

                 Field1

                 Etc.

      FROM Extract_Day_1 AND Extract_Day_2 AND Extract_Day_3 AND Extract_Day_4 AND Extract_Day_5 etc.

       

      Thanks,

      Gerhard