Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
Is there a way to do an incremental update of the data (only reload new data)
without loading the entire data of the db.
Hi Faryal,
You can try to use Partial Reload.
P.S. Be carefull with QUALIFY statement in script.
Check this DOC. Partial Reload Easy and Simple
Hope it helps.
Andrei
The easiest way is to use where condition, something like:
Load
*
where mydate > datelimit
so all new items will be loaded (I've done the example with a date, the most common situation)
Hope it helps
Hi Faryal
Attached files may help you and if you still have any problem then let me know
i don't understand partial RELOAD how it's work
In script you add "ADD" before LOAD statement.
And you should use Ctrl+Shift+R instead of Ctrl+R - to reload script.
When "compiler" see ADD or REPLACE word before LOAD it checks for changes in loaded table and add (or replace) only new (or changed) data.
Hi Faryal,
You can make a new DBfile like QVD by using just 'Reload'
and dont need a entire data.
you just add 'plus content' on previous file.
I used concatenate.