7 Replies Latest reply: Oct 3, 2012 6:13 AM by ALEXIS TAN RSS

    Identify the end of file

    Leni Balakrishnan

      Hi friends,


      I would like to know whether we can set a field after each document load. Let me explain the scenario in detail below:


      I have a set of files in a folder like file1.txt, file2.txt, file3.txt, etc.,


      I will be loading these files to the Qlikview like:


      Load * from file*.txt;


      Now I need to add a field to add the file name that I m loading.


      My output should be like,


      field1     field2     field3

      x          2              file1

      y          45            file1

      z          8               file2

      a          8               file3


      I need field, field3 which will be added dynamically.


      Or is there any other way to set a value to check end of file and use that in an another load statement.


      Thanks in Advance



      Leni Balakrishnan