Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

How can I standardize address?

Kinetic_analytics
ボリード

Hello:

How can I standardize the date from  "

387 Wellington Ave. 
YorktownVA23693

 

 

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

 

Thanks

3件の返信3
binuacs
アルクトゥルス
Kinetic_analytics
ボリード

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

binuacs
アルクトゥルス

@Kinetic_analytics 

Uppercase([street_address] + ',' + [city] + ',' + [state]+ ',' + toString([zip_code]))
ラベル