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
Solved! Go to Solution.
@Madhur12 there are duplicate Customer names from left input of Join hence you are not getting required output
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]:
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
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.
Worked for me. Thank you so much @AndrewDMerrill ! Appreciate it.😊