Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload.
Hi,
You can also save the tables you want to keep into QVD files, then load only the pieces you need. Or even do two load steps, for example:
// This one loads without WHERE condition, all records
Invoices:
LOAD *
FROM InvoicesHistoric.qvd (qvd);
// This one only loads part of the data, and appends to the above
CONCATENATE (Invoices) LOAD *
FROM InvoicesToday.qvd (qvd)
WHERE Store = 1000;
Hope that helps.
Miguel
hi,
you can do a partial reload (ctlr+shift+R). In the script, put REPLACE before each load in the tables you want to reload. Tables without REPLACE won't change.
Excellent and thanks….
How do you set it so that while sitting on the server and the server refreshes, that it is a partial reload?
Hi,
You can also save the tables you want to keep into QVD files, then load only the pieces you need. Or even do two load steps, for example:
// This one loads without WHERE condition, all records
Invoices:
LOAD *
FROM InvoicesHistoric.qvd (qvd);
// This one only loads part of the data, and appends to the above
CONCATENATE (Invoices) LOAD *
FROM InvoicesToday.qvd (qvd)
WHERE Store = 1000;
Hope that helps.
Miguel
Miguel,
Thanks….
I have partial reload working on my desktop. How do I tell the server to only do a partial reload each time?
Thanks,
Don
Don,
at the time you create a task for your source document on the server, you will come to the Reload screen, there is an option for "partial reload".
Hi Swuehl,
Excellent, thanks………
The job is being run, will update after completes.
Thanks again for the pointer, I have not done any server administration yet and this was a great pointer.
Don
Any idea why there are extra tables created with -1 appended to them when using Partial Reload and Replace option on a table?
See below log entry, two of the tables have -1 attached to the name:
FunctionalUnitApi << ( 7,817 lines fetched
CodeCoverage-1 << ( 636 lines fetched
CodeCoverageDetail-1 << ((meta_reporttype 23,416 lines fetched
I found this in the documentation and Qualify is used throughout the load and select scripts and the 60+ charts dependent on the data do use the qualified names....
Note
The
qualify
statement should not be used in conjunction with partial reload!
What other option exists to keep loading data but for one table have it not reload each time and not delete the existing table?