Each case goes through several steps. Currently, I only have the start date for the first step and the duration for the remaining steps. Now, I want to calculate the date based on the previous step and the duration in the current row. See also the attached Excel file with an example.
Knime_workflow.xlsx (10.3 KB)
Welcome to the forum!
You can achieve this by:
- using group loop to iterate over each ID (I take that are your unique identifiers)
- processing all steps for one ID inside a recursive loop - using column expression incl. “Window Size” feature (Advanced tab) you can reference the date of always the first row and calculate the date for the second row…
Prototype available here:
LeadTimeCalc.knwf (93.7 KB)
WF Overview:
Column Expressions settings:
3 Likes
4 Likes
That is actually the simpler one :-). Gosh drawn to recursion so easily xD
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.