Get Time Difference between Row 2 and Row 1, with respect to Dimensions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Solved! Go to Solution.
- Labels:
- Datasets
- Date Time
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@caltang
I made some improvement to the solution above to consider the date difference just in case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Find in attachement the easiest way to do that I think.
Let me know if the solution works on your side.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/