2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you uninstall it, and then install the latest 2022.1.1.30961 version.

Alteryx Designer Discussions

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

Combining / linking similar names together?

TiffanyLy27
8 - Asteroid

TiffanyLy27_0-1656006921652.png

 

I would like to combine the highlighted examples into one manufacturer name. They are obviously the same but has variations in the name. What tool would I use to do this?

 

The first highlighted fields should just be "AstraZeneca" 

 

Any assistance is appreciated!

2 REPLIES 2
amadra
7 - Meteor

Hi @TiffanyLy27 - You can use Fuzzy match to identify non-identical duplicates like in your dataset.
More info here: https://help.alteryx.com/20221/designer/fuzzy-match-tool

Hi @TiffanyLy27 

 

You can build a Lookup Table that has the names to be used and then use a Find & Replace tool to Append the Desired name and with a Formula tool you can replace Original Field with Desired one.

christine_assaad_0-1656007975793.png

Fuzzy matching with Make Group could also be used. There is an example that shows how this can be done, if you go to Designer, Fuzzy Match open example and scroll to the bottom of the page.

 

Hope this helps. Cheers!

Labels