2 Replies Latest reply: Nov 4, 2013 11:33 AM by Abhinav Agarwal RSS

    Incremental load based on filename

    Abhinav Agarwal



      I need to have an incremental (only add) of some log files in a QVD.


      The file name is of the format filename_date_time;csv. And there is a new file added every hour.


      For the incremental load of the QVD how can I compare the last file loaded in the QVD and the latest log files in the folder so as to load only the files that have not been loaded?


      Is it better to maintain a list of log files in a separate table?


      Load *, filename() as name
      From f:\Qlikview\*.csv


      Load *

      From f:\Qlikview\*.csv

      where ...?


      Thank you in advance,