Incremental Load/Update

Diinkant — Tue, 24 Jan 2023 03:52:03 GMT

Hi, I am running into issues where I am unable to update/insert data into my current QVD based on updated data from a query.

My code is as follows (I have tried a few things and I still can't get it to work):

Load my current QVD (all the fields are identical, the Locations table does have a lot more fields but that is because there is data coming from other queries as well.

Locations: Load * From OLD QVD Information;

Run SQL to find updated information and join that with my current QVD through resident Locations

Stock: Load productcode as [Product Code], exstock, dtc "date_updated", "time_updated"; SQL Select STOCKUPDATED.ProductCode, STOCKUPDATED.exstock, STOCKUPDATED.dtc STOCKUPDATED.date_updated, STOCKUPDATED.time_updated FROM STOCKUPDATED WHERE STOCKUPDATED.date_updated >= DateValue('$(vLastRunDate)') and STOCKUPDATED.Time_Updated >= TimeValue('$(vLastRunTime)'); left Join(Stock) Load "Product Code" Resident Locations;

I then load all data from my OLD QVD then concatenate the updated information to that but then it doesn't update (does nothing pretty much)

Final: NoConcatenate Load * Resident Locations; Concatenate(Final) Load * Resident Stock Where Not Exists("Product Code");

I've tried left joins, joins, concatenate at different parts, new fields, multiple things but nothing seems to update the data. I even tried loading the Stock (updated one) table then concatenate that with my OLD QVD but that only pulled through my updated values, where i want both my updated and old QVD to be on there.

Am i missing something here? Any help appreciated!!

Re: Incremental Load/Update

Diinkant — Tue, 24 Jan 2023 20:33:46 GMT

Bump, anyone help please

topic Incremental Load/Update in QlikView

Incremental Load/Update

Re: Incremental Load/Update