Overlapping dates: detection and handling
Hello Knime community,
First post here, so I hope I am clear enough in my request so you can help me please.
You have an excel file, with the input and desired ouput.
4 columns:
ID = people id
ID_2 = input id
Start_date
End_date
The goal is to have no more overlapping dates, while keeping as much data as possible and favouring the most recent data.
To deal with it, it is sometimes necessary to recreate entries by splitting up the input.
In the output, datas in green are datas that have been changed. One line is green and crossed out to show you that it’s normal for it to disappear, as the entries ID2 = 204313878 and ID2 = 204313879 have completely taken the place of the entry ID2 = 201234715. We prefer the ID2 = 204313878 and ID2 = 204313879 entries as they are more recent (higher ID2).
Thank you very much in advance. I’ve started down a few different ideas, but I can’t get to the end of any of them.
Fanny