Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an excel below.
I want to remove or Eliminate F1 column and row GPSE Compliance Dashboard row and load the rest of fields and values in Qlik sense.
Please provide the script.
Hi,
When you are using the load interface you can change the header size
I am loading the data from weblife and don't get the options. How to modify in the script?
For an Excel file I have :
LOAD
*
FROM [lib://External Data/excelfile.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Feuil1);