Options

Date_diff of two string Attributes

Gopal_DesaiGopal_Desai Member Posts: 12 Contributor I
edited June 2020 in Help

Hello everyone,

i have one Table (as you can see in photo). i would like to calculate Date_diff, if wert (Column) is equal to 0 then timestamp (Column)- timestamp-1 (Column). But problem is column timestamp and timestamp-1 are nominal (String). so i can not able to substract this two columns with Date_diff function. If anyone know could you please help me out?

Thank you

Best Regards,

Gopal 


Best Answer

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,509 RM Data Scientist
    Solution Accepted
    Hi,
    Likely you want to use Nominal to Date operator or parse_date function first before doing date_diff.
    Best,
    martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.