The data frame looks like this: IDDateDevice IDSeller IDInitial Time100110th Oct 20221001-18000 10:26:33 100110th Oct 20221001-1800010:34:33100210th Oct 20221002-1900015:04:12 Basically, I want the difference between rows. For example, for ID 1001 - The time difference is 8 minutes. I want to do it on Alteryx for 600k rows - all with respect to the ID and Seller ID. How can I do this?

Get Time Difference between Row 2 and Row 1, with respect to Dimensions

The data frame looks like this:

ID	Date	Device ID	Seller ID	Initial Time
1001	10th Oct 2022	1001-1	8000	10:26:33
1001	10th Oct 2022	1001-1	8000	10:34:33
1002	10th Oct 2022	1002-1	9000	15:04:12

Basically, I want the difference between rows. For example, for ID 1001 - The time difference is 8 minutes.

I want to do it on Alteryx for 600k rows - all with respect to the ID and Seller ID.

How can I do this?

Datasets

Developer

Developer Tools

Date Time

Accepted answers

grazitti_sapna

Hi @caltang , you can use multi-row formula tool to get your result. Please find the solution and screenshot. And do accept my solution if it was helpful.

Time_Diff.yxmd

All comments

grazitti_sapna

Hi @caltang , you can use multi-row formula tool to get your result. Please find the solution and screenshot. And do accept my solution if it was helpful.