community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to find the eligibility gap

Highlighted

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

 

MEMBERSTART DATE END DATE
ABCD6/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 DATE
ABCD6/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.

Nebula
Nebula

Hi @rishangoshai

 

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. 

 

Solution.png 

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

Thanks Dan for the quick response. This is exactly what I needed. It worked perfectly.

Labels