Eliminate Duplicates Rows

farolito20 — Fri, 21 Dec 2012 22:19:00 GMT

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 😕

topic Eliminate Duplicates Rows in QlikView

Eliminate Duplicates Rows