Discussion board where members can learn more about Qlik Sense App Development and Usage.
We have loaded data for 365 days in QVD. And have around 3L rows.
Now we have written incremental load as follows as we want to check last 60 days data and concatenate with existing QVD which has 1 year data
From QVD where Date > (vDate..last 60 days)
Load * from Existing.qvd where not exist (ID)
when we are doing this rows are getting reduced to around 75K. I am assuming its taking only last 60 days data. Ideally it should take for complete year and should check for 60 days for update.
Are we missing on anything?
By reading it i feel your ID may not be unique enough to use it as a condition. You may want to use a combination of your ID and Date as the unique ID.
Please try and let me know.
Hi..yes we have ID as combination of Date and ID already..
try combining the 'Details' field also
or you can change your base table
Load * from Existing.qvd