Fuzzy Match in Alteryx equivalent tool in Dataiku

Dilver

Hi Team,

I am migrating a workflow from Alteryx to Dataiku where I encountered a tool called Fuzzy Match in the Alteryx which actually compared 3 columns and generate a new column that satisfies partial matching criteria.

Below is the input data

seller_notes_prepared_stacked_sample.xlsx

Uploaded Sep 10, 202422.83 KB

Below is the configuration in Alteryx tool

Below is the sample output in Alteryx

How to achieve this in DataIku? I tried Fuzzy Join but of no luck as I was unable to configure it and didn't find the similar options in the configuration settings.

Please anyone help me in doing this and it will be great if explained with screenshots of configuration from DataIku or share the sample workflow here

Thanks & Regards

Dilver

Operating system used: Windows

Grixis

Hello,

I don't know exactly what alteryx does, but if I understand your description correctly, it's like a relative column matching, which exists on Dataiku :

Fuzzy join: joining two datasets — Dataiku DSS 13 documentation

So you can match columns with this.

But as a developper plus what I can see in your screenshots, may it's more advanced, I know there are python libraries where in two lines you can define a treshold and match columns with conditions.

I checked this one, which you can apply the same treshold params as in your config screenshot above;

fuzzywuzzy

Best,