calculate Date_Diff between same value in one Column
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
MartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,345 RM Data ScientistHi @Gopal_Desai ,did you check the date_diff function in Generate Attribute? Seems like this is what you want to use.
Best,Martin- Head of Data Science Services at RapidMiner -