Activity overview
Latest activity by habbott
Thanks for your reply but I know how to filter the records on different, missing, additional, or matching records - I'm looking for a way to filter the columns in a record on whether a column contains any differing values.
For example if I have a table with 50+ columns and over 400 different records (so I've already removed the matching, missing and additional records) but only a few columns contain different values, how can I find these columns? Once I've found which ones contain different values then I know I can edit the project and only select those columns to be displayed.
The other thing that would be useful would be to be able to sort a column and it orders the records to those with differences in this column and those that match as that would be an easy way to find columns which have differences.
Is this possible?
Thanks / comments
Thanks for your reply but I know how to filter the records on different, missing, additional, or matching records - I'm looking for a way to filter the columns in a record on whether a column conta...
Find columns with no differences to exclude them
I am comparing 2 tables which have over 50 columns. They apparently have over 400 different records. I would like to be able to find and exclude the columns which do not have any differences so o...