In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fuzzy matching do not work as expected

Mette_Foss
5 - Atom

Hi,

 

I am having this problem with the fuzzy matching, where I cannot find any settings that match the three rows below - I have tried multiple settings, and also the address, zip code, company match etc. - see below.

For the tree rows Kreditornumber, Bogføringsdato, and Beløb I am looking for an exact match - it is for the Ekstern Faktura fuzzy match (Ideally with a 80 pct. threshold) the problems appear - the three lines do not come out as matched rows.

Can anyone help me with the settings that match the three rows? I have more than 80K lines in my dataset, so it is important that the rules are not too weak - because then I will receive too many false positives. 

 

RecordIDKreditornumberBogføringsdatoEkstern FakturaBeløb
13605049422-02-23AX391059150.620,25
23605049422-02-23AX391060150.620,25
33605049422-02-23AX391061150.620,25

 

Mette_Foss_0-1685635876670.png


Mette_Foss_1-1685635941976.png

 

Thanks in advance,

 

Br,

 

Mette

2 REPLIES 2
lynnesonney
8 - Asteroid

@Mette_Foss Fuzzy match is really more of an art than a science. For IDs like your "Ekstern Faktura," I recommend changing the match function to Character oriented rather than words. Also - keep in mind that "Generate Keys" is based on the way text SOUNDS, so this isn't very useful for IDs like we have here. I would recommend trying a setup like THIS  (see images)  on your full data set and evaluating if this meets your needs. 

 

Be sure to accept this as a solution if it works!

lynnesonney
8 - Asteroid

For reference, workflow attached. 

Labels
Top Solution Authors