Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Incremental LOAD

Dears,

I'm using a FOR EACH Loop with 2 Loads inside, something like this:

For Each Sticker in 'AZUL4', 'ITUB4', 'CVCB3'...

Each Sticker is a file, loaded online...

DemonstrativoResultados:
LOAD... From...

Join (DemonstrativoResultados)
LOAD... From...

Next Sticker

 

So, every time I get a new file, I'm loading everything again and it's obviously unnecessary... 

My question is: 
How can I load just the new file, and insert it in my project without losing all old data?

 

Check this example:
Let's suppose I have the files 'AZUL4.csv' and 'GOLL4.csv'; I'm currently doing something like this:

For Each Sticker in 'AZUL4', 'GOLL4',

DemonstrativoResultados:
LOAD... From...

Join (DemonstrativoResultados)
LOAD... From...

Next Sticker

 

And now, let's suppose I got a new file, called 'ITUB4.csv'

I don't want to load 'AZUL4', 'GOLL4', 'ITUB4'. Is there any way to just load the 'ITUB4' and add it to my database?

 

Thanks for your attention,
Best regards

2 Replies
brunolelli87
Creator II
Creator II
Author

Any help?

brunolelli87
Creator II
Creator II
Author

Any idea guys?