How to find the eligibility gap

Question

I am trying to calculate member's eligibility from the following data.

MEMBERSTART DATE END DATEABCD6/1/20177/31/2017 8/1/201712/31/2017 3/1/20184/30/2018   EFGH10/1/20156/5/2017 6/6/20177/5/2017 7/6/20179/30/2017 10/1/201711/30/2017 3/1/201812/31/2199   MNOP4/24/201710/19/2017 10/20/201711/30/2017 3/20/201812/31/2199

And this is what i want to see from the above data to calculate eligibility in months.

MEMBERSTART DATE END DATEABCD6/1/201712/31/2017 3/1/20184/30/2018      EFGH10/1/201511/30/2017 3/1/201812/31/2199      MNOP4/24/201711/30/2017 3/20/201812/31/2199

I am very new to Alteryx . Any help would be appreciated.

danilang · Accepted Answer

Hi @roshangoshai

You can do this by finding the first row of each period, then the last, removing all the rows between and changing the end row start date.

Note that from your input data it looks like as long as the start date of one row was the day after the end date of the previous row, the rows could be combined into a single period.  If this is not correct, you'll have to provide the actual criteria

Dan