Forum Discussion
Fuzzy matching based on names and dates
Hi,
I have two tables and I need to match approximate names from both tables but making sure the occurence is on the same day. Will the fuzzy matching work on this case or should I create a new column on each table to concatenate Name&Date, then apply the matching?
Table 1:
| Name | Date |
| John Smith | Jan 01, 2020 |
| John Smith | Feb 01, 2020 |
Table 2:
| Name | Date |
| Jon Smith | Jan 01, 2020 |
Thanks!
Hi Anonymous ,
We can try to set Date column as first match condition when merge to meet your requirement (use Ctrl to select multi columns)
Best regards,
2 Replies
Hello Anonymous
you can try to transform your date to text before applying the fuzzy join. Problem could be that when you have similar dates, that they are matched too.
Hope this helps
Jimmy
Hi Anonymous ,
We can try to set Date column as first match condition when merge to meet your requirement (use Ctrl to select multi columns)
Best regards,
