ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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
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 ANTWORT 1
dreldrel
Comet

Could you please share the example datasets?

Beschriftungen
Top-Lösungs-Autoren