Hi,
I have imagine 3 columns, id, start_date, end_date.
ID contains duplicates so if a certain customer has multiple contracts, they will show up on list multiple times. I am trying to get a deduped list in most cases.
Most contracts are like the following
1, 1/1/2015, 12/31/2015
1, 1/1/2016, 12/31/2016
I can just dedupe the list, and do min array function and max array function to get the min and max start dates. I have this figured out. I need help with non-consecutive ones.
ID, Start_date, End_Date
2, 1/1/2015, 12/31/2015
2, 5/1/2016, 12/31/2016
2, 6/1/2017, 3/31/2018
So in this case I can't dedupe b/c I cannot do min max since the contract is not all the way through the min and max dates.
So I want to be able to identify these types of contracts through a IF statement or any other way so I can manually add these to the deduped list.
Bookmarks