Compare two reports on a specific field and filter if information is not identical

Question

Dear all,

I have two tables with identical headers, one source table and one created table from other data and I want to cross check that all information is identical and filter on data which is not.

example

smoosh · Answer

I've tweaked the cross-tab method to work across any number of columns. Try it now.

Good luck.

TableCheck_v2.yxmd

geraldo · Answer

they will come out through the L and R outputs when they don't match

Nicolaas_Vercruyse · Answer

Great thanks,

The join seem not to be sufficient as I actually want to filter on ID's which are in both reports but not having the same information.

The cross-tab does make it happen, but it only checks one column, in this case the code. But the differences could be in all columns. In my real report I have about 7 columns that would need to be checked if identical...

Thanks!