Hi,

I have two sets of data that are in a slightly different formats to be compared. I need to be able to see what the differences are between two reports in regards to what groups users are in. Example tables:

Table 1 - Groups

Name User Groups
Bob bob1 AAR1 AAR2
Jack jack1 AAR1 AAR2 AAR3

Table 2 - Actual Groups

Name User Group
bob2 Bob AAR1
bob2 Bob AAR2
bob1 Bob AAR3
jack1 Jack AAR1
jack1 Jack AAR2

In the example, you can see how Bob is only supposed to be in AAR1 and AAR2 but he also is in AAR3. As for Jack, he is supposed to be in AAR1, AAR2 and AAR3, but according the second table he's not in AAR3.

So what is the best way to compare a large amount of data in this format?

Hope this makes sense and thanks for reading !

- zan