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 ,

Can you describe some details of the data set you are working and what you are trying to accomplish with it so a solution can be proposed to you?

Thanks.

Best,

Roland

Infotopics - Benelux partner of the year

Empowering business through analytics. See, Understand, Act!

[RWvanLeeuwen · Accepted solution]

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!