0 Replies Latest reply: Jul 26, 2016 11:32 AM by Ankit Gupta RSS

    How to load unstructured data in Qliksense

    Ankit Gupta

      Hi , I have a excel file with me (Attached: Test Data Qlik) which contains unstructured data, it have following anomalies:

       

      1. Have blank rows between data, I want to get rid of those.
      2. Have a Parent Product in One cell of Column and then Child product line in multiple cells in other column. I want Parent product to be replicated in front of each child product line.

       

      If you see the excel file, the left side is the current state of the data I have and the right one is the desired state. Can someone please help me with guidance on how to profile data in this case?