Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

caltang
17 - Castor
17 - Castor

The data frame looks like this:

 

IDDateDevice IDSeller IDInitial Time
100110th Oct 20221001-1

8000

10:26:33

100110th Oct 20221001-1800010:34:33
100210th 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?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
5 REPLIES 5
grazitti_sapna
17 - Castor

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.

 

grazitti_sapna_0-1665720004049.png

 

Sapna Gupta
Qiu
21 - Polaris
21 - Polaris

@caltang 
I made some improvement to the solution above to consider the date difference just in case.

1014-caltang.PNG1014-caltang-2.PNG

binuacs
21 - Polaris

@caltang Similar to @Qiu and @grazitti_sapna solution

 

binuacs_0-1665727319954.png

 

Emmanuel_G
13 - Pulsar

@caltang 

 

Find in attachement the easiest way to do that I think.

 

Let me know if the solution works on your side.

 

Emmanuel_G_0-1665741285063.png

 

caltang
17 - Castor
17 - Castor

Dear @grazitti_sapna @Qiu @binuacs @Emmanuel_G 

 

All your solutions work perfectly! I've actually did it myself and forgot to update the thread. But my solution is similar to what you all wrote.

 

Thank you!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors