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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delete Incremental Days

Hi Everybody

Im trying an Incremental Load of last 17 months from today. The Load will be every day but my data of my last 2 days could change, my question is:

How can I delete 2 days before today and then replace them with the new data loaded today?

Thanks!!

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Load the most recent two days of data and then concatenate from the QVD where not exists the key (or the date if you prefer or don't have a key).

View solution in original post

2 Replies
johnw
Champion III
Champion III

Load the most recent two days of data and then concatenate from the QVD where not exists the key (or the date if you prefer or don't have a key).

Not applicable
Author

Thanks Again John!!