Thank you for helping me learn alteryx better.
Probably the easiest way to do this would be with a formula tool with this formula
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE([Old],"Street","St"),"Road","Rd"),"Avenue","Av"),"Lane","Ln"),"Boulevard","Blvd")
could you please attach the workflow?
could you please share the workflow with me?
How about I have to replace 20 different "words"? in that case, do I need to use replace 20 times?
Yes, with this method you would have to use the Replace for as many words as you have.
Did the other solution above provided by @oliverd not solve your issue? If so, please reassign the solution tag accordingly
Thank you for accepting my solution!