Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to find the eligibility gap

roshangoshai
6 - Meteoroid

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.

2 REPLIES 2
danilang
19 - Altair
19 - Altair

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. 

 

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

roshangoshai
6 - Meteoroid

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

Labels