9 Replies Latest reply: Jul 24, 2012 4:38 PM by Wojciech Parzyszek RSS

    Text file into Qlikview

      I have the following text files that I need to bring into a qvw. I wasn't sure how to do it.

       

      The format of them is the same and I will be getting a new one every month which means this will have to take from all files with, say, CICS* in the name so I don't have to import the new one every month. All I want to have to do is put the new file in the folder with all of these files.

       

      I need the "DATE", "# of T/XS" and "AVG RSP" column. The last column can be calculated if need be.

       

      I don't need the Totals either. Those can be calculated. Just the raw data.

       

      Please help!

      Thanks