Hey all,
I've got a bunch of policy data that has issue date and termination date (which may or may not be null). I'm trying to figure out how to split each record based on its "policy anniversary."
For example, let's say a policy has an issue date of 10/10/2007 and termination date 12/10/2009. I want to create separate records for each of these date ranges:
Using DummyID 4 in my sample data as another example, my desired output is as follows:
DummyID | Policy_Start_Date | Policy_End_Date |
4 | 1954-09-20 | 1954-12-31 |
4 | 1955-01-01 | 1955-09-19 |
4 | 1955-09-20 | 1955-12-31 |
4 | 1956-01-01 | 1956-09-19 |
. | ||
. | ||
. | ||
4 | 2019-09-20 | 2019-09-24 |
Does anyone know how this can be done?
Solved! Go to Solution.
Hello @jrdnjhnsn2
You should be able to use multiple filter tools to do this.
If you provide a sample of your data, myself or someone else in the community can create a sample workflow using the filter tool, or other tools.
Hi @jrdnjhnsn2 ,
Here is a simple example where I'm using the formula to flag the policy and then using a advanced function from the output data tool to separate the data into different excel tabs.
Best,
Fernando Vizcaino
Hi @Sntrada, I attached a sample of my data to my question. Let me know if you need anything else. Thanks!
Hi @jrdnjhnsn2 ,
I've checked out your data and re-read your question. I don't think a simple stacked filter solution would work here. Sorry! Maybe someone else can help.
Hi @jrdnjhnsn2 ,
I think now I've understood what you need.
What do you need to do when you don't have the termination date? To treat as today's date or simply ignore?
Best,
Fernando V.
Hi @fmvizcaino ,
I was literally just thinking I forgot to say what to do for the null termination date cases. I'd like to just enter today's date.
Thanks,
Jordan
Apologies @jrdnjhnsn2, I found some bugs in how my previous workflows dealt with null termination dates.
This is now fixed. Please find updated version attached.