RapidMiner 9.7 is Now Available

Lots of amazing new improvements including true version control! Learn more about what's new here.

CLICK HERE TO DOWNLOAD

Dealing with Missing Dates

JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 570   Unicorn
edited November 2018 in Help
Hi,

I'm trying to replace missing (NULL) values in a date field with today's date. 
I first tried a GenerateAttributes operator using IF(MIssing(fieldname),date_now(),fieldname), but this threw a syntax error. 

Anyone have any suggestions?

Thanks

Answers

  • Marco_BoeckMarco_Boeck Team Lead Software Engineering Administrator, Moderator, Employee, Member, University Professor Posts: 1,936   RM Engineering
    Hi,

    try this:

    if(missing(Date), date_now(), Date)
    Regards,
    Marco
Sign In or Register to comment.