I have two tables,
old_record
id,name,age
new_record
id,name,age
In some cases, the information in new_record is the same at the old_record, and I need to create one table with all the information from the two tables.
So, I use Autonumberhash(ID,NAME,AGE) to compare the information.
old_record:
load
AutoNumberHash256(ID,Name,Age) AS key1
from DimCustomers_Day0.qvd (qvd);
new_record:
load
AutoNumberHash256(ID,Name,Age) AS key2
from DimCustomers_Day1.qvd (qvd);
Then I wanna compare, but I don´t know how 😕