5 Replies Latest reply: Apr 11, 2017 5:49 PM by Marco Wedel RSS

    How can I remove all rows after an empty one?

    Henrik Happel

      Hey guys,

       

      I am new to QlikView.

      I like to read Data from a .txt file. It works for the normal reading.

      But in the .txt file, there are 4 blocks of data.

      I just need the first block. The blocks are separated by an empty row.

      I found the command for removing an empty row but I need to delete all rows after that empty row.

       

      Further, I want to read in as many .txt files as there are in a folder.

       

      Please help me with this or give me a hint where I can look up those information.

       

      Thanks,

      Henrik