Discussion Board for collaboration on QlikView Scripting.
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?
Message was edited by: Elad Nadav
What you tried looks right. Can you share the Excel workbook?
Excel workbook was added to the post.
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:
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.