topic Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload in QlikView

Exclude data sources during reload but retain data

Tue, 29 Nov 2011 15:54:43 GMT

Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload.

Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

christophebrault — Tue, 29 Nov 2011 16:12:32 GMT

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.

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Tue, 29 Nov 2011 16:17:16 GMT

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?

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Miguel_Angel_Baeyens — Tue, 29 Nov 2011 16:38:47 GMT

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

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Tue, 29 Nov 2011 17:13:45 GMT

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

Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

swuehl — Tue, 29 Nov 2011 18:32:37 GMT

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".

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Tue, 29 Nov 2011 22:44:46 GMT

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

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Tue, 29 Nov 2011 23:49:15 GMT

Any idea why there are extra tables created with -1 appended to them when using Partial Reload and Replace option on a table?

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Tue, 29 Nov 2011 23:50:29 GMT

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

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Wed, 30 Nov 2011 00:15:15 GMT

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?

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Wed, 30 Nov 2011 02:40:18 GMT

Miguel,

Turns out since Partial Load can not be used in this case because Qualify is used throughout, that the QVD solution you mentioned above is the perfect solution. There may be some scripting around this but this will work.

Thanks,

Don

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't reload

Miguel_Angel_Baeyens — Wed, 30 Nov 2011 18:12:50 GMT

Hi,

That may happen usually when the table is labelled like any other previously loaded. Or it may happen because you don't use labels for tables (setting a name before the LOAD statement see my example above) and two tables in the source are named alike.

Hope that helps.

Miguel