We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Configuring Fuzzy match for strings starting with digit

harish_alt
6 - Meteoroid

Hello,

 

I am developing a workflow to fuzzy match strings as shown below.

 

1-Nokia

Nokia

2,3-iPhone

4uPhone

 

Standard Names:

 

Nokia

iPhone

4uPhone

 

I am expecting below output:

1-Nokia : Nokia

Nokia : Nokia

2,3-iPhone : iPhone

4uPhone : 4uPhone.

 

My Fuzzy match tool configuration now:

harish_alt_0-1620189048033.png

 

Please help me to reconfigure to achieve the required output. Thanks.

 

 

 

 

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hi @harish_alt ,

 

Alteryx automatically uses the first letter as the first key word character, so it is not possible to match names with no identical first letters/digits, so what we can do is to create a dummy character to make it all work.

 

Take a look and let me know if it makes sense.

 

Best,

Fernando Vizcaino

Labels
Top Solution Authors