The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Date_diff of two string Attributes

Gopal_DesaiGopal_Desai Member Posts: 12 Learner II
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

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 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.