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.

Clean Company Names and Create a Workflow

rturpin
5 - Atom
‎04-27-2023 04:17 PM

I have datasets for R&D Expenditures and Patents Granted Per Year (see excel files). I need helped cleaning the company names so the data from the two excel files can be joined in a manner where a correlation can be found between R&D Expenditures and Patents granted from 2012-2018. Can anyone provide tips or a workflow that achieves my objectives?

Preview file
562 KB
Preview file
141 KB
Reply
0 Likes
1 REPLY 1
Qiu
21 - Polaris
21 - Polaris
‎04-27-2023 04:26 PM

@rturpin 
Maybe you can try the Fuzzy Match tool.

Reply
0 Likes
Community Live
Labels
Top Solution Authors
View All