Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

fuzzy matching question

TomzPwC
6 - Meteoroid

I have two excel sheets. One have a sheet called "Detailed Sold rev & backlog AUG" which has "Client Name (as per SUN / Salesforce)" in column F from row 6 (row 5 is header). Second excel file has a sheet called "Client wise data used" which has "Client name" in column A from A3. Column B3 has "sector" mentioned in it. "Client Name (as per SUN / Salesforce)" and "Client name" needs to be fuzzy matched and corresponding "sector" in the second excel file has to be recorded in the first excel file in column O from O6.

How can this be done through Alteryx

1 REPLY 1
dreldrel
8 - Asteroid

Could you please share the example datasets?

Labels
Top Solution Authors