12 Replies Latest reply: Dec 12, 2016 2:22 AM by Marcus Sommer RSS

    Calling data from textfile into qliksense/qlikview

    john cena

      Hi,

       

      I have a .txt file which has data as below:

       

      defect::1234|:defectfrom:Q1111|:defectto::Q9999|:component::billing|:status::completed|:

      defect::1235|:defectfrom:Q1111|:defectto::Q1111|:component::billing|:status::pending|:

      defect::1236|:defectfrom:Q9999|:defectto::Q1111|:component::payments|:status::open|:


      this .txt file has no headers.


      My requirement is to pull that data into qliksense and convert it into a .QVD file.


      The challenge here is getting the column names/Headers pulled.


      can someone guide me on how we can pull such a kind of data


      Thanks in Advance.

      John