I guess I could have posted the script outside the QVD:
UpdatedData.qvd (qvd); // Let's say I have 100 records I want to change.
Where Not Exists(VIN); // Let's say I have 999,990 records I don't need to change.
Master.qvd (qvd); // Is there a more economical way to do this?
It just seems like you should be able to do something like:
set Master.Damage = UpdatedData.Damage
From Master INNER JOIN UpdatedData on Master.VIN = UpdatedData.VIN;
Presuming the VIN values are unique, you could save a few steps using the ApplyMap() function along with a previously loaded mapping table on your new Damage values as follows, replacing the code under the "Cumbersome" tab in your original document:
Mapping LOAD VIN, Damage
From UpdatedData.qvd (qvd);
LOAD VIN, Loc, ApplyMap('map_UpdatedData', VIN, Damage) as Damage
From Master.qvd (qvd);