Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

State abbreviations in Allocate

I'm still relatively new, so I trust someone will correct and instruct me if this already exists. I have looked and have not been able to find it.

 

It would be nice if there was an option to return the standard 2 letter abbreviations for states from the Allocate Input tool's "Pick Variables" "geographic Identifiers." Currently, the only identifiers available are "Key" an"Name":

 geographic identifiers.gif

Where, Key is numeric ("02", "44", etc.), and Name is the full state Name. In order to join to most of our databases, I usually need this to be the standard 2 letter abbreviation. This forces me to join to another database table to translate it.

 

2 Comments
phoebe_kelley
9 - Comet

I agree, this would be super helpful!!

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes