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: 
kakani87
Specialist
Specialist

Incremental load by looping multiple files

Hi Everyone,

In Qliksense scripting

I'm having multiple months of data files in  different files with me

Now i want to load the multiple files by looping the data should be incremental load

my approach to load all the files would be like

LOAD tran_date,

     month,

     Item#,

     Sale,

     Qty

FROM

[..\..\Include\TAB*.xlsx]

(ooxml, embedded labels, table is Sheet1);

to load multiple tables.

2 Replies
marinadorcassio1
Partner - Creator
Partner - Creator

Hi,

Have a look to this thread : How to automatically load all Excel data using qlik sense desktop

Regards,

Marina

tomasz_tru
Specialist
Specialist

What exactly you want to achieve?

Here's a good one on incremental: https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/