Join operation on partially matching fields

[noopurjain]

Hello,

I would like to perform a join operation on the datasets using fields that do not have exact matches. In the provided example, my goal is to join dataset 1 and dataset 2 based on the address field, even though the addresses are not identical in both datasets. Is there a method to perform the join based on an 80% to 90% match criteria? I have specified the desired output.

Thanks

[Raj]

@noopurjain have you tried Fuzzy match.

[Raj]

Refer this workflow
this will give you a understanding of the similar case.
(workflow was posted on community not build around your case but will help.)