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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Load data from excel

Hi,

I am trying to load the attached excel file in Qlikview. The data fields are in rows and I would like to load into Qlikview as separate fields.

Any help will be much appreciated.

Regards,
Daniel

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Take a look at the Generic Load prefix. https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

That will be the base of your solution. It looks like you will also have to use some where clauses to filter out header rows. 

-Rob