Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Exclude data sources during reload but retain data

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

1 Solution

Accepted Solutions

Re: 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

11 Replies
christophebrault
Valued Contributor

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

Not applicable

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

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

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

Not applicable

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

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

MVP
MVP

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

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

Not applicable

Re: Can you reload from multiple data sources but exclude one and still keep the data for the one you don't 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

Not applicable

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


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

Not applicable

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

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

Not applicable

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

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?