Multiple singe day events grouped as single consecutive day events

I am trying to figure out a way, in Magic ETL, to take multiple single day events and group them when there is break in consecutive days.

Example, if the results show the 1st, 2nd, 3rd, 5th, 6th, 9th, 10th and 11th, I need three results, not 8. I want to see begin and end dates of 1st-3rd, 5th-6th, and 9th-11th.

Any thoughts?

Best Answer