I am trying to calculate member's eligibility from the following data.
MEMBER | START DATE | END DATE |
ABCD | 6/1/2017 | 7/31/2017 |
8/1/2017 | 12/31/2017 | |
3/1/2018 | 4/30/2018 | |
EFGH | 10/1/2015 | 6/5/2017 |
6/6/2017 | 7/5/2017 | |
7/6/2017 | 9/30/2017 | |
10/1/2017 | 11/30/2017 | |
3/1/2018 | 12/31/2199 | |
MNOP | 4/24/2017 | 10/19/2017 |
10/20/2017 | 11/30/2017 | |
3/20/2018 | 12/31/2199 |
And this is what i want to see from the above data to calculate eligibility in months.
MEMBER | START DATE | END DATE |
ABCD | 6/1/2017 | 12/31/2017 |
3/1/2018 | 4/30/2018 | |
EFGH | 10/1/2015 | 11/30/2017 |
3/1/2018 | 12/31/2199 | |
MNOP | 4/24/2017 | 11/30/2017 |
3/20/2018 | 12/31/2199 |
I am very new to Alteryx . Any help would be appreciated.
Solved! Go to Solution.
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
Thanks Dan for the quick response. This is exactly what I needed. It worked perfectly.