Comparing data between two identical tables

[#1]

Hi All,

I have a data table in one database that I'm migrating to another. So the data should be exactly the same. Is there a good way to compare two tables in the QlikView script to find data discrepancies?

I read this before opening a new thread http://community.qlik.com/message/65158 but does anyone know something of more efficient than using explicit join ?

Is there an easy way to see only the rows that are different using some function (like arithmetic subtraction) ?

Thanks

[prieper]

Think not, if you wish to compare both tables, with the possibility that there might be orphans in either table.

If you have a master-table (containing all records) and need to find the missing values in the other table, you may check the EXISTS()-function:

Master: LOAD * FROM Master;

Check: LOAD * FROM OtherTable WHERE NOT EXISTS(key);

DROP TABLE Master;

Might depend on the number of records, and might be worth for you to test, whether such solution has a better performance than the proposed JOIN.

HTH
Peter