Alteryx Designer

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

convert field data before join

Highlighted
6 - Meteoroid

I would like to take the results of my Input Data and convert the data from one column. For example, Saint Louis University would be translated to SLU; the University of Missouri would be translated to MU. What is the best tool for this? Can I import a spreadsheet with the translations or do I need to create different formulas? Any help is appreciated! Thank you, in advance!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@jhouseslu ,

 

Using a FIND REPLACE tool, you can read a substitution list and get these normalized.  You just need to have the translations.  The tool is flexible enough to ignore capitalization too.

 


Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
6 - Meteoroid

This worked perfectly. Thank you.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@jhouseslu,

 

You're welcome!  Glad to lend a hand.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels