Incremental Load

[HAmzehAF]

Hello, 

i want to use Incremental Load in my qvd to get only the data when load, but

im saving the data(history) into the qvd by doing this cuz no history in the database so i save it on the qvd to get the history day by day 

DAILY_SALES:

LOAD distinct

    LOCN,

    DOCNO,

FROM [lib://QVDs (win)/DAILY_SALES.qvd]

(qvd);

Concatenate

Load*;

SELECT 

"LOCN",

"DOCNO",....


1) so now i want to get only the new data and put them on this like data for sales 10/13/2023 only to load when i load the data again how can i do this? 
-- 

2) also i want to know if i had to change anything in the qvd like i had the sales in 2022 OCT wrong can i edit that?
--

3) i upload the qvd on onedrive to cloud to use it on the qlik cloud how can reduce the size of the qvd to upload it faster cuz now its 5gb and it takes lots of time

[vincent_ardiet_]

Do you have a unique identifier key for your rows (like for example [MyUniqueKey])?
If this is the case, start loading the dataset from the database.
Then Concatenate data from the QVD with a where clause like:
Where Not Exists([MyUniqueKey])