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

[Nicolaas_Vercruyse]

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

[geraldo]

@Nicolaas_Vercruyse 

use join tool with all columns as keys

[smoosh]

Attached is an example file that shows two ways it could be done. 

• One is a join (as noted in a comment above).
• The other is a cross-tab using the ID and Code value with testing function. 

Either works and will hopefully get you going in the right direction.

Take care. 

[Nicolaas_Vercruyse]

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!

[geraldo]

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

[smoosh]

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

Good luck.