Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anuhyak1
Creator
Creator

Eliminate first row and first column from Excel while loading data in Qlik sense

I have an excel below.

Anuhyak1_1-1667423798710.png

 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.

Anuhyak1_0-1667423693786.png

 

3 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

When you are using the load interface you can change the header size

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/select-data-fie...

 

amartinez35_0-1667469750192.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
Anuhyak1
Creator
Creator
Author

I am loading the data from weblife and don't get the options. How to modify in the script?

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

For an Excel file I have :

 

LOAD
*
FROM [lib://External Data/excelfile.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Feuil1);

Help users find answers! Don't forget to mark a solution that worked for you!