4 Replies Latest reply: Aug 5, 2011 1:55 AM by Nick Gan RSS

    Load from multiple text files (dynamic)

      From my payroll system, every two weeks a text file is created, which I need to load into qlikview

      The text files are all stored in the same hard drive folder (C:\textfiles\) and are named

      Payroll_week13-14.txt
      Payroll_week15-16.txt

      The format of the files are completely the same, and they all need to be concatenated into the same Qlikview table.

      How do I create a load statement that dynamically loads ALL text files, no matter if there are 3 or 300 in the folder?
      I also need a datafield in the qlikview table that contains the source file name.

      Please help. [:D]

      regards, Jesper