Find Overlapping Timestamps
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
peddy
7 - Meteor
‎10-08-2020
03:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I couldn't find the exact solution to my problem, so creating a new topic.
I have the following dataset:
Customer ID | Product ID | Start Date | End Date | Value |
111 | 111 | 20200131 | 20201231 | 1 |
111 | 222 | 20200131 | 20201231 | 2 |
111 | 333 | 20200131 | 20201231 | 3 |
222 | 111 | 20200131 | 20201231 | 4 |
222 | 222 | 20200131 | 20201231 | 5 |
222 | 222 | 20200401 | 20200415 | 6 |
222 | 333 | 20200131 | 20201231 | 7 |
333 | 111 | 20200131 | 20201231 | 8 |
333 | 111 | 20210131 | 20211231 | 9 |
I need to create a workflow which adds a column at the end and flags the records that overlap with other ones. So in the example above records with values 5 and 6 should be flagged.
FYI...The real dataset contains around 100k records.
Thanks,
Pedram
Labels:
- Labels:
- Date Time
16 REPLIES 16
‎10-12-2020
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wow - This is great - thanks!
However, when I open the workflow I'm missing a part of it. Do you mind resending it please.
‎10-12-2020
07:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried to guess the formula and settings for F&R, but the results were incorrect...
‎10-16-2020
05:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ACE Emeritus
‎10-16-2020
05:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry @peddy had missed this - will take a look and get back to you
ACE Emeritus
‎10-16-2020
05:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ACE Emeritus
‎10-17-2020
02:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-19-2020
10:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks - think it looks good! 🙂

- « Previous
-
- 1
- 2
- Next »