Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
nadavel85
New Contributor

MS excel header disrupts data load

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:

2018-06-20_1444.png

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

2018-06-20_1446.png

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

4 Replies
mwoolf
Honored Contributor II

Re: MS excel header disrupts data load

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

nadavel85
New Contributor

Re: MS excel header disrupts data load

Excel workbook was added to the post.

MVP & Luminary
MVP & Luminary

Re: MS excel header disrupts data load

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
New Contributor III

Re: MS excel header disrupts data load

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