You can use a mapping load to get from one table the correct values and apply to the second table. If there are a lot of fields, this can be cumbersome... Here you are an example on how this works
RightNamesMap: MAPPING LOAD EmpID, Name; SQL SELECT EmpID, Name FROM Employees; DataWithWrongNamesAndCorrection: LOAD EmpID, Address, Name AS OriginalWrongName, ApplyMap('RightNamesMap', EmpID, Name) AS RightName; SQL SELECT EmpID, Address, Name FROM Employees;
The key here is the MAPPING prefix in the first table and the ApplyMap() function in the second. What this will do is to check each value of EmpID on the second table and return the value of "Name" in the first table. If the first table doesn't have the EmpID (meaning the second table has already the correct name) then the second table value of "Name" will be kept (hence the "Name" as the third parameter in the ApplyMap() function.
Hope that makes sense.