Discussion Board for collaboration on QlikView Management.
How to script without mentioning header line ????? while loading the excel data .
(ooxml, embedded labels, header is 4 lines, table is [Dept]);
Go to Solution.
Maybe select None under Labels.
unable to get headers name if i select none
Goto File wizard transform and delete rows and columns not required,but with this solution in script n statements for rows and columns will be displayed which is worse than header line mentioned.
other solution is request source provider to give spreadsheets with only one header(Change the format).
you can rename column names with header names from excel ,if none is selected
I think once you do what I suggested, you should get something like this:
You can name them to be whatever you want like this:
F1 as Something1,
F2 as Something2,
i cnt make changes in excel as per client instruction
yes you can't change with out clients instructions but request them to provide data with format( one line header)
you can follow sunny's solution and rename fields in UI with header names from excel.