Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music

How To: Combine Date Ranges with a Macro

Alteryx
Alteryx
Created

How To: Combine Date Ranges with a Macro


This module (and embedded batch macro) will provide a comprehensive timeline or date range(s) using multiple, overlapping date ranges.
 

 


 The macro converts date ranges into spatial objects in order to use the spatial functions in Alteryx to group overlapping or adjacent ranges. This ensures that ranges A and C get are grouped together when A and C do not overlap but both A and C overlap range B (and so forth for larger chains of ranges).

 

 

2019-04-22_12-01-32.png

 

 

 

It also allows for “jumping” a user-determined number of days in order to combine regions that do not overlap but are within a specified number of days of one another.


2019-04-22_12-03-16.png

 



 

 

Attachments
Comments
7 - Meteor

This article was EXTREMELY helpful for our use case!  Thank you for sharing the insight here!