ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
binu_acs
ポラリス
Kinetic_analytics
ボリード

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

binu_acs
ポラリス

@Kinetic_analytics 

Uppercase([street_address] + ',' + [city] + ',' + [state]+ ',' + toString([zip_code]))
ラベル
トップのソリューション投稿者