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
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!
they will come out through the L and R outputs when they don't match