Generate new Attributes with some calculations
I am new here and i don't have that much experience in Rapidminer. I have one Table in MySQL Database and i connected my Database with Rapidminer via MySQL. I get table from Database in Rapidminer like this. As you can see in Photo. Column 2, It shows Time when object comes on station. For example in First Row, Object 4B6B831A comes on station Arbeitsplatz1 at 04.03.20 13:49:29. When This Object leave the station(As you see in Row 2),It shows Wert=0 on station Arbeitsplatz1 at 04.03.20 13:49:41. Now I would like to add new Column (Process Time), It should Calculate time difference between 2nd Row and 1st Row. And it should show me in column(Process Time),
Same thing for ID(Column 1) 10 and 12. It should show me timestamp difference in new Column (Process Time).
I don't know how to calculate this thing every time, Whenever values has been added in Table. If anyone know could you please help me out.
Thank you in advance