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

       

      Thanks,

      Leni Balakrishnan