Options

Dealing with Missing Dates

JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 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

  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering
    Hi,

    try this: 

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