Hello Community, i am having trouble with a document i am working on.
I have this table (i am just giving an example, the table is bigger) where i have an id_person, an initial date and a Final_Date. I have alredy made some scripting to get the initial period and the final period for each id and concatenated these periods in a field called Period. The thing that i need to solve now is to generate the periods missing between the initial date and the final date. I only need to generate the Period field, the date fields would remain the same.
This is the example of how my data is
And this is how i want it to be:
So, the id_person 1 would have as many registers as periods it has, and the id_person 2 would remain the same because is only one period.
Please, if someone can help me, I can´t work out the solution.