![Screenshot 2025-11-17 at 18.36.51.png](qxzYyO7yY5Sf)

**Prepare recipe**: 
- If 1-to-1, all rows are deleted before Stack recipe.
- If 1-to-many, primary rows prefectly matched are cleaned and put back into the process.

**Stack recipe**: 
- If 1-to-1, one of the input is empty.
- If 1-to-many, rows perfectly matched from primary dataset are added.

**Fuzzy join recipe**: 
 
The first step involves a fuzzy join recipe, which combines datasets based on keys and distance thresholds set in the Project Setup. These thresholds define the acceptable level of dissimilarity between values in the key columns.

A distance of 0 indicates a perfect match. Distances are calculated using Euclidean distance for numerical values, Levenshtein distance for strings, and the difference in seconds for dates.

 **Prepare and Split recipes** :
 
In subsequent recipes, matches with key distances exceeding any threshold are classified as "no match," ensuring that only pairs within the specified limits are included in the analysis. Remaining matches are classified as "potential" or "pending" for further review.

