calculate Date_Diff between same value in one Column

Gopal_Desai

Hello everyone,

I am working with MySQL Database and Rapidminer. I already connected Rapidminer Software with MySQL Database and i get this kind of Table(as you see in photo). Now i would like to calculate Date Time difference between Eingang(Column) and Ausgang(Column). For example For value 4B6B831A (in Column wert-1), i would like to calculate date time difference between Ausgang and Eingang (Jan 4, 2020 1:54:38 - Jan 4,2020 1:49:29 = 00:05:09) . Same for the value 027A4428, It should be  Jan 4, 2020 1:56:13 - Jan 4, 2020 1:50:13 = 00:06:00. I would like calculate every time whenever new values in table update. If anyone know How can i perform this calculation?

Thank you in advance

Best Regards,

Gopal   

MartinLiebig

Hi @Gopal_Desai ,

did you check the date_diff function in Generate Attribute? Seems like this is what you want to use.

Best,

Martin

MartinLiebig

Hi @Gopal_Desai ,

did you check the date_diff function in Generate Attribute? Seems like this is what you want to use.

Best,

Martin