I've tried reading through all the partial reload information available but am still at a loss on this one.
I have a QVD with data from the last few years, with the primary key being AttendanceID, and a field called DateUpdated which indicates when the record was last updated. There are a bunch of other fields as well. Due to the length of time it takes to run the QVD, we only plan to do a full reload once a quarter.
In my head, we need to load the QVD into TABLE1, and then using partial reload (1) remove any AttendanceID which have a new DateUpdated entry in the SQL database, and populate the new details from the SQL database into TABLE1 for those AttendanceID. Step (2) is to append records to TABLE1 with all the fields for any AttendanceID which isn't in the QVD but is now in the SQL database.
Any help appreciated. Thanks.
#qliksense
