Dear community,
we have a set of historical employee data. Each row represents a period of time for an employee. If something changes in the contract, the current contract will be closed (-> “valid to”-date added) and a new line is added.
Unfortunately, the “valid to” is missing for some rows.
The data is sorted by “EmployeeID” and then by “valid from”.
The “valid to” should be added based on the following line, if the “valid to” is empty. (date - 1 month) For most “employeeID”, there should be one row with no “valid to”-date and 0:n rows with “valid to”-dates.
3 examples in green, blue and purple:
sample data (9.1 KB)
In Excel, this could be easily done by sorting the data as in the example and adding some if-functions. How do you do this in KNIME? Is there a way to use the rowID to write data from one row into another? Which Nodes do we have to use?
Any Input is very much appreciated.
Chris
