Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

How can I standardize address?

Kinetic_analytics
11 - Bolide

Hello:

How can I standardize the date from  "

387 Wellington Ave. 
YorktownVA23693

 

 

     to:  387 - Wellington AV, Yorktown, VA, 23693 

 

Thanks

3 REPLIES 3
binuacs
20 - Arcturus
Kinetic_analytics
11 - Bolide

It is solving my problem. How could I make it all caps? Appreciate your help in my learning process. 

binuacs
20 - Arcturus

@Kinetic_analytics 

Uppercase([street_address] + ',' + [city] + ',' + [state]+ ',' + toString([zip_code]))
Labels