Hi HansS and thanks for the reply. This was very useful!
By the way I would like to add a specific quation on this topic:
|Start.Date| | End Date | Value | Price | Document |
|01.10.2018|31.01.2021||165.000,00|123.750,00|1015253862|
|01.07.2019|30.09.2020||165.000,00|41.250,00|1015253862|
|01.10.2019|31.01.2021||165.000,00|220.000,00|1015253862|
How to be sure in this case that I will have the last end date in the first column? And if I have the same end date for the same contract, how to tell knime that i want two separate iterations?
like:
Document | Start.Date | End.Date |
|1015253862|01.10.2018|31.01.2021|
|1015253862|01.10.2019|31.01.2021|01.07.2019|30.09.2020|