Date Month Names - numbers to titles.

miked

Hi All - Is there an easy way to convert Date Month Number (0,1,2,etc) into month names (Jan, Feb,etc) other than the below general if statement?

if(eval(%{Data_Month})==0,"January",
if(eval(%{Data_Month})==1,"February",
if(eval(%{Data_Month})==2,"March",
if(eval(%{Data_Month})==3,"April",
if(eval(%{Data_Month})==4,"May",
if(eval(%{Data_Month})==5,"June",
if(eval(%{Data_Month})==6,"July",
if(eval(%{Data_Month})==7,"August",
if(eval(%{Data_Month})==8,"September",
if(eval(%{Data_Month})==9,"October",
if(eval(%{Data_Month})==10,"November",
if(eval(%{Data_Month})==11,"December","N/A"))))))))))))

@sgenzler

MartinLiebig

Hi,

you can turn it into a nominal and use a Map operator or Join a mapping table?

Best,

Martin

miked

Thanks!