How to compare strings from 2 different data sources

Question

Hello,

Below is my query

Excel 1, column 1:

Namepineapple sciencesHello freshtomato garden

Excel 2 column 1:

Namepineapple sciences ltdoriginaltomato 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/

madhurinani · Answer

Thank you. 
let me try using your logic.

binu_acs · Answer

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

FuzzyMatch_12_07.yxmd

madhurinani · Answer

@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?