How to compare strings from 2 different data sources

[madhurinani]

Hello,

Below is my query

Excel 1, column 1: 

Name

pineapple sciences

Hello fresh

tomato garden

Excel 2 column 1:

Name

pineapple sciences ltd

original

tomato ltd

The o/p should be only row #1 and #3 based on a fuzzy match. I tried using a join condition but was unable to do it.

How can i achieve that?

Thanks/

[binu_acs]

@madhurinani You cannot match the fields using join tool because these fields are not exactly matching. in this use case fuzzy match is the best option

[madhurinani]

---

@binu_acs 

But Fuzzy match doesn't allow 2 input parameters, correct?

I have those columns coming from 2 different data sources.

How do i achieve using Fuzzy match then?

[binu_acs]

@madhurinani you can union the dataset and try using fuzzy match tool, try different options in the Match Syle drop down box 

[madhurinani]

Thank you. 
let me try using your logic.