topic Comparing data between two identical tables in QlikView

Comparing data between two identical tables

Mon, 30 May 2011 09:18:34 GMT

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

Comparing data between two identical tables

prieper — Tue, 31 May 2011 20:48:54 GMT

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