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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
2 Replies
brunolelli87
Creator II
Creator II
Author

Any help?

brunolelli87
Creator II
Creator II
Author

Any idea guys?