If you want to do a fuzzy join, you can do this by doing a fuzzy lookup to add a column to the top dataset. Note that you can set Bottom value column to the same as Bottom key column to see the matches. Once you are happy with the results you can select the Lookup item and click the To File button at the bottom of the Left pane to output the results into a new file.Check case sensitive to use case sensitive matching for keys.Set If no match depending on what you want to do for rows in the top dataset with no matches.

If there are multiple values that are equally good, use all of them. All best if you want to use the best matches.If there are multiple values that are equally good, use the first one. First best if you want to use the best match.set it to 80% to make 2 values that are 80% the same a match. Set Closeness to how close a fuzzy match has to be to be considered a match.Then in the Right pane set the Top key column and Bottom key column to the common (‘key’) column and set the Bottom value column to the value you wish to lookup. Ensure that the Lookup item is selected.Select the two input items using Ctrl+click (PC)/Cmd+click (Mac) (or by dragging a box around them) and click the Lookup button in the Left pane.Make sure the dataset you wish to lookup values in is vertically below the other dataset. Drag your 2 datasets onto Easy Data Transform.Make sure the Auto Run button is pressed in. There is a fully functional free trial and you don’t have to give us your email or sign up to anything. Install Easy Data Transform on your PC or Mac, if you haven’t done so already.You can try fuzzy matching with Easy Data Transform yourself: But you can cross-reference two inexactly matching datasets using the Fuzzy matching option in Easy Data Transform’s Lookup transform.Įasy Data Transform scores fuzzy matches against “McDonald’s” (case insensitive) as: Text For example, McDonalds might be spelled “McDonald’s”, “McDonalds”, “McDonald”, “Macdonalds”, “Mc Donalds” or “McDonald’s Corp.”. The name of a company might be spelled in various different ways, with different uses of spaces and punctuation. Real-world data is often messy and inexact.

Fuzzy lookup excel mac download