community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Cleaning Email address domains

Hey mmeth,

 

I tried the Fuzzy match email you recently uplaoded - however it doesnt seem to work when i attach my data.

 

The field name is correct - but it only runs to 50% on the fuzzy match and says "the key generation might not be selective enough for optimal performance".

 

Any ideas?

 

Thanks,

Kerry

Bolide

In the fuzzy match tool you have to select what type of field you are dealing with in the Match Style, as it applies different matching rules for names as opposed to zip codes, etc. 

 

The match style I selected in the sample I gave you was 'Name', since we were just trying to match one word strings. Does the field you are trying to match only contain one word strings? I know the example I gave you didn't include '.com', which could throw it off. If your strings include this I suggest parsing out the '.com' part. 

 

Best,

mmenth

Labels