Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to set a character limit?

I am trying to abbreviate everything in a specific column of my data (e.g. Make New Jersey say NJ and New York, NY). How do I set a character limit to 2 letters so everything shows up abbreviated?

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @bryce-ciccarelli1 

 

You can set size in select tool.

 

You can abbreviate using the below formula. And also set column size to 2 for the new column.

 

Workflow:

atcodedog05_0-1625671486048.png

 

Hope this helps 🙂

 

That helped thanks!

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @bryce-ciccarelli1 

Labels