MS excel header disrupts data load - Qlik Community

Anonymous · ‎2018-06-20

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

m_woolf · ‎2018-06-20

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

Anonymous · ‎2018-06-21

Excel workbook was added to the post.

marcus_sommer · ‎2018-06-21

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

makrishnaraj · ‎2019-04-04

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