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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem loading data from xls

Hi guys,

if an excel has the format of content like below:

productJanFeb
salesprofitssalesprofits


what is the best solution to load them? thanks in advance!

1 Reply
Miguel_Angel_Baeyens

Hi,

I guess you mean how to load what in excel are rows as fields (columns) in your script.

I'd recommend you to take a look at this file and use the code in it to load first sales, then profits.

Hope it helps.