Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional STORE when using limited load

Does anyone know how to make the STORE command optional based on full reloads only? This would be helpful on incremental loads so the stored QVD data is never overwriten by an incomplete data load.

I need a function like "=IsFullReload()"

Thanks

Cliff

1 Reply
pover
Partner - Master
Partner - Master

Not sure there is a function, but you could do 2 inline table loads. One would be an Add Only Load and the other a normal Load. They would each load a column called Flag and in the Add Only Load it loads a 0 and in the normal Load a 1. With a peek() assign the value of the Flag to a variable that you can then use to evaluate if it is a full (1) or partial (0) load.

Regards.