The challenge is to find the minimal set of intervals without creating gaps. There is a table with groups of redundantly overlapping date intervals where each group has no gaps. Given this table, your job is to find the minimum set of date intervals witho

The challenge is to find the minimal set of intervals without creating gaps. There is a table with groups of redundantly overlapping date intervals where each group has no gaps. Given this table, your job is to find the minimum set of date intervals witho

The challenge is to find the minimal set of intervals without creating gaps. There is a table with groups of redundantly overlapping date intervals where each group has no gaps. Given this table, your job is to find the minimum set of date intervals witho

This is a 3rd attempt at the solution. This solution will replace all previous solutions. This solution corrects a hard coded number with some scripts.

!. Sort Startdate by GroupID and assign a row number to each row 2. Count items in each group 3. Find the Disjoint Startdate to gauge the possible gaps 4. Find the minimum connecting groups as Keypoints 5. List the first and last items as anchors 6. I

This solution is to replace an earlier solution submitted. While the older solution appears to give an answer to the sample given when I added in some more dates a hole appeared. This newer solution overcomes that problem. Regards.

This is a 3rd attempt at the solution. This solution will replace all previous solutions. This solution corrects a hard coded number with some scripts.