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


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).







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.





7 - Meteor

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