# Fuzzy Join

{% hint style="info" %}
This tool is currently in Beta and is still being tested. Want to learn more? Like to provide feedback? Please reach out to <support@cascade.io>
{% endhint %}

Fuzzy Join allows for the combination of  two datasets into a single table, based on a similar shared column.

*Note: Fuzzy Join always functions as a **left join** type*&#x20;

### Input/Output

| Input                                                                                         | Output                                                                                                      |
| --------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- |
| <p><strong>Left Table</strong> - any table</p><p><strong>Right Table</strong> - any table</p> | Single table with merged data from **Left Table** and **Right Table** and an additional match\_score column |

### Options

| Option          | Description                                                                                                                                                           |
| --------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Left Field**  | Column in the Left table that shares similar values with the Right table                                                                                              |
| **Right Field** | Column in the Right table that shares values with the Left table                                                                                                      |
| **Threshold**   | Threshold allows you to limit results to only rows with match scores above a set value. The match\_score determines the best match for each combination when joining. |

The FuzzyJoin tool will not automatically update while in the tool view. When you are finished selecting your prompts, simply click the 'Update' button in the bottom right corner to run the tool.&#x20;