Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

How to load unstructured data in Qliksense

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?