checking for duplicate records

[Madhur12]

I have made a macro from a sample dataset to check for duplicate records. I am trying to do a comparison between customer no and customer name. My goal is to check if 2 customers have the same customer no. If the customer no and customer name is same, it is not a duplicate. Attached is the macro and the sample dataset.

I am not able to get the results I want when I run the macro on another dataset. Attaching that as well (dataset 2). Can anyone please help me here?

Thanks,

Madhur

[AndrewDMerrill]

I think you need to include one more Summarize before your current Summarize to Group By both [Customer No.] and [Customer Name]. That way literal duplicates (same # & Name) are removed:

[nagakavyasri]

@Madhur12 there are duplicate Customer names from left input of Join hence you are not getting required output

[AndrewDMerrill]

Whoops! @nagakavyasri- makes a good point. I forgot about the Left side of the Join. I think are both incorrect however, considering the problem statement, I believe you will need to add two Summarize tools (You could also use the Unique Tool instead) in order to isolate unique  combinations of [Customer No.] & [Customer Name]:

[Madhur12]

Thanks @nagakavyasri @AndrewDMerrill !

So there are 2 checks I'm trying to run on my dataset through this macro:

1. Different customer number but same customer name:

2. Same customer number but different customer name:

Is it possible to get both these results using a single macro, i.e. (sorting ascending by customer name and sorting ascending by customer number - may be using 2 anchors and 2 browse tools) ? 

Thanks!

Madhur

[Madhur12]

Also, I want my output to only give me duplicates both for 1 and 2 above and not to give me unique customer number and customer name combination.

[AndrewDMerrill · Accepted solution]

I'm not exactly sure what you're looking for, so here are two options in one macro, just delete the top two branches or bottom two branches depending on which you prefer:

[Madhur12]

Worked for me. Thank you so much @AndrewDMerrill ! Appreciate it.😊