Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Joining time and date attributes to form date_time attributes

wesselwessel Member Posts: 537 Maven
edited November 2018 in Help
Dear all,

What is an efficient way of combining date and time attributes into a date time attribute?
E.g. first attribute = days of epoch e.g. 31-11-2013
E.g. second attribute = time of day e.g. 14:55:02

Best regards,

Wessel

Answers

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
    Generate Attributes operator is the first I can think of.

    Combine the two attributes with Concat into a text string and then use custom parse date to convert to a date_time. 
  • wesselwessel Member Posts: 537 Maven
    Hey Edward,

    You are right, this works, thanks.

    If possible, I would prefer to not have to parse dates.
    This was missing from my original question.
    In generate attributes there seems to be a date_add() function.

    Best regards,

    Wessel
  • wesselwessel Member Posts: 537 Maven
    I think you can do this:

    date_add(Date, MyNumberOfMinutesAttributeGeneratedWithDateToNumerical, DATE_UNIT_MINUTE)
Sign In or Register to comment.