Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.