3 Replies Latest reply: Aug 11, 2015 6:57 AM by Friedrich Hofmann RSS

    Header lines in an Excel file to LOAD

    Friedrich Hofmann


      Hi,

       

      I'm again having trouble with the nr. of header lines in an Excel file that we get from a customer and that I have to load to analyze it: There are two sheets,

      - one has 6 lines above the column_headers (counted in Excel)

      - one has 5 lines above the column_headers (counted in Excel)

       

      QlikView, however, seems to automatically delete one line on the first sheet where there is nothing at all - there is some text starting in line #2 - so specifying 5 header_lines in the LOAD_wizard works for both sheets.

      I wonder why that is? Does QlikView do that, is that expected behaviour? I just want to know whether I can rely on that ...

       

      Can anybody help me out there?

      Thanks a lot!

      Best regards,

       

      DataNibbler