Fuzzy Match query - How do I add more record ID fields

Question

Hi,

I'm using Fuzzy match to match records in a column but I notice that the Output is always just the single Record ID fields from both the input sources. Currently, I have to execute multiple Fuzzy matches and multiple join the outputs by position.

Please refer to attached picture for reference.

Any advice would be great. Thanks!

Fuzzy match query.jpg

abeljohnson · Answer

abeljohnson · Answer

Thanks for responding. But I don't see the Output Mode in the Options Tab. This is what I'm seeing -

Raj · Answer

If you're using the Fuzzy Match tool in Alteryx, the default output mode is to only return the Record ID fields from both input sources. However, you can configure the tool to output additional fields by using the "Output Mode" option.

To do this, follow these steps:

* Open the Fuzzy Match tool and go to the "Options" tab.
* Under the "Output Mode" section, select "All Fields" or "All Fields + Match Score" depending on the level of detail you need in the output.
* If you select "All Fields + Match Score", you can also choose to output the Match Score as a field in the output.
* Configure any other options you need for the tool, such as the Match Style, Match Threshold, and Match Types.
* Run the tool and check the output to confirm that the additional fields are included.

By selecting "All Fields" or "All Fields + Match Score", the Fuzzy Match tool will output all fields from both input sources in addition to the Record ID fields. This can save you the trouble of having to execute multiple Fuzzy matches and joins.