hi all,
I am quite new to KNIME and unfortunaltely stuck in a comparisson i want to set up.
I want to compare the values of rolling dates in a table. For every month I need to check the amount column of the previous 12 months (see column example 1,2, table below). The task is to automatically filter all dates, that have at least 6 or more (out of 12) previous months where amount = 0
ID | Amount | Date | ||
A | 0 | 201509 | ||
A | 0 | 201510 | ||
A | 0 | 201511 | ||
A | 0 | 201512 | check if Amount=0 | |
A | 0 | 201601 | check if Amount=0 | check if Amount=0 |
A | 3 | 201602 | check if Amount=0 | check if Amount=0 |
A | 5 | 201603 | check if Amount=0 | check if Amount=0 |
A | 0 | 201604 | check if Amount=0 | check if Amount=0 |
A | 0 | 201605 | check if Amount=0 | check if Amount=0 |
A | 1 | 201606 | check if Amount=0 | check if Amount=0 |
A | 2 | 201607 | check if Amount=0 | check if Amount=0 |
A | 0 | 201608 | check if Amount=0 | check if Amount=0 |
A | 4 | 201609 | check if Amount=0 | check if Amount=0 |
A | 3 | 201610 | check if Amount=0 | check if Amount=0 |
A | 3 | 201611 | check if Amount=0 | check if Amount=0 |
A | 0 | 201612 | check if Amount=0 | Start date |
A | 0 | 201701 | Start date |
I need to repeat the procedure for every entry in the date column. Does someone have a "simple" solution for it?
Thanks a lot!
Best,
Stephan