Alteryx Designer Desktop Discussions

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

Multiple replace expressions in the Multi Field Tool

ABCDA
7 - Meteor

Thanks for the continued support!

 

Wondering if it is possible to have multiple expressions in the Multi-Field tool?

 

For example:  I currently have the following expressions working with one expression per Multi-Field tool. (Currently making this replace in 2 address fields). Was looking to have multiple expressions in the tool.

 

Multi-Field Tool 1 has the following expression:  Replace([_CurrentField_], 'AVENUE', 'AVE')

Multi-Field Tool 2 has the following expression Replace([_CurrentField_], 'PARKWAY', 'PKWY')

Multi-Field Tool 3 has the following expression Replace([_CurrentField_], 'STREET', 'ST')

 

Any help would be greatly appreciated.

2 REPLIES 2
Bren_Spill
12 - Quasar

@ABCDA  - try this:

 

replace(replace(replace([_CurrentField_], "AVENUE", "AVE"), "PARKWAY", "PKWY"), "STREET", "ST")

 

Multi Replace.JPG

 

ABCDA
7 - Meteor

Thanks!  Worked perfectly!

Labels