community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Recognizing Data and Converting it to a specific abbreviation

I've got data that I need to run against each other. This data is different schools, however, in the reports that I am joining the schools have their full names written out, and in the SQL query that is also being joined the schools are referenced by their abbreviation. How can I get alteryx to match the school codes together or convert one of the data sources to using the others format? Here's a specific list of the schools in question.

Pulsar

You can do this using an additional Join.  Join one of your data sets to your conversion table to pull in the "other half" of the code/school pairing.  Then join this new field to the second data set.  Something like:

image.png

You'll need to decide which pieces of data you need to keep (i.e. adding Unions after the Joins to get left joins if desired), but this should solve your formatting issue.

Highlighted

Thank you for your help!

Labels