Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Miguel_Angel_Baeyens

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

View solution in original post

11 Replies
christophebrault
Specialist
Specialist

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.

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable
Author

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?

Miguel_Angel_Baeyens

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
Author

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

swuehl
MVP
MVP

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
Author

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
Author


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
Author

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
Author

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?