Quick summary
The Fuzzy Match tool in Alteryx lets you identify near-duplicate records across datasets using configurable match methods and thresholds. This step-by-step walkthrough shows how to configure and run Fuzzy Match inside the Alteryx workflow designer from start to finish.
Steps
- In the Alteryx workflow designer, locate Fuzzy Match in the left-side panel, drag it onto the canvas, and connect it to your Input Data tool or other data sources.
- In the right-hand panel, begin configuring the tool by choosing your preferred Find Method.
- Select your preferred Row ID Column and set your desired Match Threshold.
- Scroll down to the Match Criteria section and specify your preferred Match Column and Match Style using the dropdown menus.
- Click Edit Match Options to access additional configuration settings.
- Configure the available match settings according to your requirements.
- Navigate to the Output Options section and tick the checkbox beside the output option you wish to enable.
- The Fuzzy Match tool will process your data and generate output results based on your configured settings.
