Alteryx Designer Desktop Discussions

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

Results of CASS Tool

Amy18
8 - Asteroid

Is there any way to change all results from CASS Tool uppercase or lowercase? 

Sometimes I got Address with the first letter capitalized and others lowercase while sometimes I got the address all capitalized. 

Thanks.

2 REPLIES 2
KyleB
Alteryx
Alteryx

You can set the Options in CASS to "Force results to CAPS." 

 

Another option would be to place a Data Cleansing Tool downstream and either do the same or assign Upper, Lower, or Title case. (both shown below)

 

Enjoy!

 

5-31-2018 7-28-06 AM.png

 

 

5-31-2018 7-30-44 AM.png

 

 

Amy18
8 - Asteroid

Thank you. 

That's what I am looking for. 

Labels