I am looking for some easy way to find differences between two records
having the same key. The dataset contains several hundred variables,
so i dont want to name the fields..
Data is something like the following...
Key_Field Field_1 Field_2 Field_3 ............
Key1 a b c
Key1 a b not-c
Key2 x y z.
Key2 x not-y z...
in the above, i would like to come up with something like following
(basically for each key identifying fields that have mismatches)..
Key1 and Field_3
Key2 and Field_2 and so on..
Any inputs, would be highly appreciated!