Date_diff different rows

christian_feise

Hello rapidminer community,

i am looking for a way to use the date_diff function in the generate attributes operator for two different rows. I have data for products with an ongoing time stamp and want to generate a new column that shows the difference between the timestap of row x and row x-1
for example
1 16:11; 00:00
2 16:14; 00:03
3 16:30; 00:16
4 16:52; 00:22

any help is appreciated. thank you very much!

Thomas_Ott

@christian_feise check out the Lag operator in the Value Series extension. You can create a second attribute column by lagging the first column, then use a Generate Attributes operator by doing date_diff(attribute1,attribute2)

christian_feise

Thanks Thomas, your proposed solution works just fine,

have a nice day!