Find Overlapping Timestamps

[peddy]

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

[peddy]

@jdunkerley79 

Wow - This is great - thanks!

However, when I open the workflow I'm missing a part of it. Do you mind resending it please.

[peddy]

I tried to guess the formula and settings for F&R, but the results were incorrect...

[peddy]

@jdunkerley79 

any idea what went wrong with the workflow you attached?

[jdunkerley79]

Sorry @peddy had missed this - will take a look and get back to you

[jdunkerley79]

Missing tool and connection restored!

Guessing when I was screenshotting deleted it!

But has problems - will see what is wrong with it and get it fixed. Will take some work - but will get a working demo for you asap

[jdunkerley79]

Try the attached.

I fixed up the last few issues. 

[peddy]

Thanks - think it looks good! 🙂