Cycle in KNIME

KNIME Analytics Platform
1

Hi there,

I would like to know if anybody has a solution for this task:

I have a file which is made by:

Document | Date | Value
356-444 | 27/11/2020 | -
356-444 | 22/09/2017 | 70
356-444 | 11/07/ 2013 | 12
821-456 | 07/01/2020 | -
821-456 | 11/09/2010 | 50
555-111 | 04/04/2015 |

so far and so on…

Desired Result:

Document | Date | Value | Document 1 | Date | Value 2 | Document 2 | Date | Value 3
356-444 | 27/11/2020 | - |356-444 | 22/09/2017 | 70 | 356-444 | 11/07/ 2013 | 12
821-456 | 07/01/2020 | - |821-456 | 11/09/2010 | 50
555-111 | 04/04/2015 |

Any help??

Thanks !!

2

Hi @Andrea-Cagnazzi

Take a look at this wf Cycle in KNIME.knwf (47.2 KB) .

Screenshot from 2020-11-27 20-55-14
Screenshot from 2020-11-27 20-55-14865×268 19.1 KB

gr. Hans

3

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|

Thanks a lot for the support