Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!