6 Replies Latest reply: Feb 2, 2018 5:31 AM by Chanty 4u RSS

    Load data from excel without text in rows

    Adam Hájek

      Hello i have excel document that is source of data for me but i have problem that qlik does not see all the data because of text in source document

      Value 1Value 2Value 3
      110100
      220200
      330300
      Value 1Value 2Value 3
      440

      400

      550500
      660600

       

      The qlik can see only the green values and do not see the data under the second value header. Is there a way how to load the data without the second header line in load script ? Some fuction to ignore the row in data load script or something.

       

      Thanks in advance