Alteryx Designer Desktop Discussions

JeffJeffrey12 · ‎01-25-2022

Dear Community,

I am trying to check a set of data where I have multiple starting and end dates for multiple people.

I am sorting the data via "PeopleID" first and then via the "Start" date. Therefore it is sorted properly.

Now I want to check if the "Start"-date of ones PeopleID is consecutive to the "End"-date of the row before that, if its the same PeopleID.

As an example I have the following example data set:

How the raw data is How I would like it to be

I hope you understand what I am trying to achieve and can help me out on that as I can't find a solution yet.

Thanks in advance!

Luke_C · ‎01-25-2022

How does this look?

JeffJeffrey12 · ‎01-30-2022

I am pretty sure, this will solve my problem, but I had to finish other things first, so I had no time to test it with true data yet.

Sorry for taking so much time.

OllieClarke · ‎01-31-2022

I've got a very similar approach to @Luke_C, but my output takes the first start and last end rather than the last of both:

Hope that helps,

Ollie

Check next row if date is consecutive