Date Month Names - numbers to titles.
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"))))))))))))
Tagged:
0
Best Answer
-
MartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,423
RM Data Scientist
Hi,you can turn it into a nominal and use a Map operator or Join a mapping table?Best,Martin- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany5
Answers