Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Start and end dates grouped by gap in dates

Grisham312
6 - Meteoroid
‎07-10-2020 07:42 AM

I'm trying to find the best way to call out date ranges that are consecutive and when there are gaps.

 

Please see my attached workflow.  The top input is my data and the second input on the bottom is my desired output showing start date and end date for the consecutive dates.

 

Thank you for any help.

Sample date range workflow.yxmd
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
cplewis90
13 - Pulsar
13 - Pulsar
‎07-10-2020 08:02 AM

Hey @Grisham312,

 

This was a tough one to work through the multi-row formula but a great way to start my morning!

 

Let me know if this is what you were looking to do and I can walk through the logic if you need me to.I attached the workflow for you. 

cplewis90_0-1594393327177.png

 

Sample date range workflow.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All