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!!
