Options

Database NULL values

greggreg Member Posts: 23 Contributor II
edited November 2018 in Help
Hi

I have a Date attribute which is sometimes missing. In that case, I use the value "NULL" when I create the field ("Generate Attributes"). In the database, I end up with the value "1970-01-01" instead of NULL. What should I do to have actual NULL values in the database?

TIA

greg

Answers

  • Options
    greggreg Member Posts: 23 Contributor II
    No one?
  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering
    Hi,

    I don't know your process setup and what exactly you do, but RapidMiner uses NaN for missing values. That should lead to null values in your database if you use the Write Database operator.

    Regards,
    Marco
Sign In or Register to comment.