topic Re: MS excel header disrupts data load in QlikView

MS excel header disrupts data load

Anonymous — Wed, 20 Jun 2018 11:53:13 GMT

Hi, I'm trying to load data from excel file that has been generated by another system.

The file has 1 header line above the labels:

When I try to load the data QlikView misses everything except the first column:

Trying to get rid of the first header line doesn't help.

Does anyone know how to get this to work?

Thanks,

Elad Nadav.

Message was edited by: Elad Nadav

Re: MS excel header disrupts data load

m_woolf — Wed, 20 Jun 2018 15:35:36 GMT

What you tried looks right. Can you share the Excel workbook?

Re: MS excel header disrupts data load

Anonymous — Thu, 21 Jun 2018 05:36:31 GMT

Excel workbook was added to the post.

Re: MS excel header disrupts data load

marcus_sommer — Thu, 21 Jun 2018 07:28:05 GMT

The merged excel-cells prevent the automatic fieldname-listing but you could just overwrite the generic fieldnames like F2 and so on within the wizard like:

- Marcus

Re: MS excel header disrupts data load

makrishnaraj — Thu, 04 Apr 2019 08:14:36 GMT

This is actually the issue with the excel file generated. The only solution for this issue is to open the excel file and save it before loading into the qlikview.

You can use some visual basic script to open the excel file and save it.

Krishnaraj