Clarification needed with date_get function.

Hi @nn_here,
in this case you can use Date to numerical operator to extract parts of your data.

Best, 
Cesar

Hi,
Thankyou for the help provided.When i used this operator it's not giving me the result in required format.date field  Jul 1,2018  i would like it to split like july (col1),day(col2)2018(col3) as i need to group by on basis of 3 in different cases.i read about date_get(Date, DATE_UNIT_MONTH, 'yyyy/MM/dd')  that would satisfy my requirements.But the format is not matching.Can you please help me in this case..
Thanks and regards,
nn_here

Hi @nn_here, 
please find attached a simple solution for this case.
best, 
Cesar

Hi, Kindly note  ,this is the expression i have added in generate attribute operator to segregate month from values in date column.

date_get(Date, DATE_UNIT_MONTH, "yyyy-MM-dd")
But unable to get correct format after even after multiple attempts.
Kindly help me in getting the correct one.
Thanks and regards.

Hi Cesar,
Thankyou so much for taking out time and sharing the process !.It really helped...
Motivates me to work on more rapidminer  operators .Thankyou.  
Thanks and regards,
nn_here

You welcome, 
We are here to share and help each other. Enjoy AI Studio (Rapidminer)

best,

Cesar

Hi,
Kindly help me in clarifying one doubt regarding missing values in 2 columns.2 columns having more than 2 lakh rows, have more than 1 lakh rows as missing values.Can you please let me know how should be deal with it.To remove the column as such or use replace missing value operator in rapid miner by replacing with sd or avg values..
Also,as part of preprocessing i have used the following operators in rapidminer,
 Replace Missing Values -> Remove Correlated Attributes -> Normalize -> Remove Useless Attributes .Is there any more operators i need to verify before getting to actual data processing.
Thanks and regards,
nn_here.