Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
divianjani
Contributor II
Contributor II

How Load Excel Columns Headers without first blank rows

Hi Everyone, Hope you all doing great !!!!

I need small help. I have one source data file like showing  in below screenshot. how to load this kind of data from the excel files into QlikVew/Qlik Sense. I want to load only Sales Person Name, Product and Sales Amount columns.
can any one help me. 

Thanks in Advance 🙂

Need to Load only Data columns.png

 


 

 

1 Solution

Accepted Solutions
Vengatesh
Partner - Creator
Partner - Creator

While inserting the data in script editor give Header size as 3 Lines and give embedded labels. it should work fine.

You Know What To Do.

View solution in original post

1 Reply
Vengatesh
Partner - Creator
Partner - Creator

While inserting the data in script editor give Header size as 3 Lines and give embedded labels. it should work fine.

You Know What To Do.