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!!
Solved! Go to Solution.
Hi @Shan_dup_298,
Find and replace work like a vlookup. Please write find in a search window and click example to explore how it works.