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

Address abbreviations in workflow

Kinetic_analytics
11 - Bolide

Hello:

How can I transform this following workflow?

 

Kinetic_analytics_0-1648137011050.png

Thanks

 

 

9 REPLIES 9
binuacs
21 - Polaris
Kinetic_analytics
11 - Bolide

Thank you for helping me learn alteryx better. 

jonnyrask
8 - Asteroid

@Kinetic_analytics -

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")

oliverd
7 - Meteor

I used a small RegEx

oliverd_0-1648140051658.png

 

Kinetic_analytics
11 - Bolide

could you please attach the workflow?

 

Kinetic_analytics
11 - Bolide

could you please share the workflow with me? 

Kinetic_analytics
11 - Bolide

How about I have to replace 20 different "words"? in that case, do I need to use replace 20 times?

jonnyrask
8 - Asteroid

@Kinetic_analytics 

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

oliverd
7 - Meteor

Thank you for accepting my solution!

Labels
Top Solution Authors