Compare Datasets with UID - Highlight fields that do not match

KFarr12

I am trying to compare 2 data sets that contain info for a group of members. Each member has a unique ID and exists in both data sets.

I would like to compare a member from both data sets and output the field names that do not match along with the members unique ID.

I have used an Only Unique function to find the members who do not have a complete match across all fields. I now need to identify which fields cause the incomplete match.

RWvanLeeuwen

Hi @KFarr12 ,

Perhaps you are looking for the Expect Equal tool that is available from this website: http://www.chaosreignswithin.com/

If not, will you elaborate on your requirements?

Best,

Roland

Infotopics - Benelux partner of the year

Empowering business through analytics. See, Understand, Act!