Incremental LOAD

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Incremental LOAD

brunolelli87 — Thu, 21 May 2020 18:01:49 GMT

Any help?

brunolelli87 — Sun, 24 May 2020 21:15:47 GMT

Any idea guys?