Hi, I have two data files I want to merge. The issue is I don't have an ID column shared by both files. Instead, I want to merge based off other criteria like matching email addresses.
How could I merge with the following rules:
if two email addresses match, the records match.
Otherwise, if the name and date of birth match, it's a match.

Also, how could I account for differences in names such as "David" and "Dave"?
Would the merge command work in this situation?