In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Vlookup add a column with state names from state abbreviations

garcshan
5 - Atom

Hello I'm very new to Alteryx. I have an excel file with state abbreviations as well as other data and I want to add a column next to the state abbreviations based on another file that has both the abbreviations and corresponding state names. I tried to use the join tool but it doesn't seem to work when there's other data in the file. Can anyone help me with making a vlookup type function so that I can get the state names pulled into a new column? Thank you!!

1 REPLY 1
Emil_Kos
17 - Castor
17 - Castor

Hi @garcshan,

 

Find and replace work like a vlookup. Please write find in a search window and click example to explore how it works. 

 

Emil_Kos_0-1624660750443.png

 

Labels
Top Solution Authors