Hi all,
I'm trying to compare columns within 2 data sets using the join tool to get records that are present between both data sets. However, the names within the data set are not identical so the join tool isn't picking up such records. I'm trying to use fuzzy match but not sure how to use it. Can anyone please help? Tysm.
I'm unable to unfortunately but an example is if one data set has 'peppers' while the other has 'peppers lite'. I want both items to be joined but the slight difference in names is preventing that. How can I use the fuzz match to compare them?
Search the training videos for "Fuzzy": https://community.alteryx.com/t5/Videos/bd-p/live-training
The Fuzzy Match tool is generally a trial-and-error effort, and will likely never give you perfect results.
You might also want to try the Find Replace tool.
Chris