Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Switch syntax error

8 - Asteroid

I try to switch the month number to the month name as below, but the result is empty....... what's going on??

Please note that the month numbers bare int 16   Thank you.



Switch([MONTH], Null(),

9 - Comet

Try switching the month column to a String. 


You can use a Select tool right before the Switch formula. 



Alteryx Certified Partner

Are you trying to create a new column or update the exiting Month column?


If you are updating the column, you should convert the month numbers to a string first using the Select tool.  If you are creating new column, your switch statement should work if you use the following:


SWITCH([Month], NULL(),

1, "Feb",

2, "Mar"



8 - Asteroid

Hi Dan, yes you are right!! I was running this query under "in database"

Unfortunately, the "in database" select function doesn't allow you to review and change the data type...

I totally missed...

Thank you.

8 - Asteroid

Hi Nick;

I was trying to update under the same column..

But since I was in "in database", the select function doesn't allow you to review and change the data type, so I totally missed it..

Thank you for your helps!