Datum berechnen

Hallo @Reader1991,

und willkommen in der KNIME Gemeinschaft!

Use following nodes:

  • Rank node with Laufzeitbeginn (Ascending order) as ranking attribute and Personalnummer as grouping attribute with Ranking Mode Ordinal. Will get rank column.
  • Math Formula node to subtract 1 from rank column ($rank$ - 1). Make sure to have Convert to Int option checked.
  • Date&Time Shift node on Laufzeitbeginn with options Use Numerical → Numerical column → rank

Assumption is that same Personalnummer always have same Laufzeitbeginn.

Did you understand? If not someone or even I can (try to) translate it :wink:

Br,
Ivan

4 Likes