In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

ToNumber(substring....

ohruud
7 - Meteor

Hi there, 

 

I have a data-set containing months as a string function (Jan, Feb, Mar etc), but not in the right order. One solution that I found was to give each month a number, thus enabeling to sort on nuber to get the right order. 

 

The expression used was " ToNumber(substring(DateTimeParse([month], "%b"),5,2))

 

However, I do not fully understand how the formula works.  Can someone explain ? 🙂

 

 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

If you break it up into individual parts, it's easier to understand the formula, see below:

 

DavidP_0-1587722978264.png

 

ohruud
7 - Meteor

Thanks 🙂

Labels
Top Solution Authors