How to join records with duplicates
i have unique emails on the left side of the join for emails that have previously bounced from a mailing list. i have contacts from our CRM on the right side of the join and in some cases we have dup...
Forum Discussion
Matt, It seems the inner join should work. The fact that you’re generating even 1 record in the output indicates to me that the join may be configured correctly. So, my first grasp at the air is maybe case sensitivity. If the CRM application has different casings for jdoe for each of the different contact records, then the join on email addresses won’t match those that are different than the left side. You might try standardizing with a $email.toLowerCase() before the join. Hope that helps.
