We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Fuzzy Lookup

SiddeshDhruva
7 - Meteor
‎08-03-2022 11:59 PM

Hi, i am looking for a help on the fuzzy lookup between supplier names, data is in two different files and the requirement is to pull the information from sheet 2 by supplier names(full or partial match), i am new to Alteryx and appreciate your guidance on this.

 

i have attached the data examples and the desired output FYR.

 

Thank you!

Siddesh Dhruva

 

 

 

Preview file
11 KB
Preview file
10 KB
Preview file
9 KB
Labels:
Reply
0 Likes
1 REPLY 1
FilipR
11 - Bolide
‎08-04-2022 04:28 AM

You can use Find Replace for that:

 

FilipR_0-1659612470518.png

FilipR_2-1659612589366.png

 

 

Partial Lookup.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All