| id | date | cont |
| 101 | 27/07/2017 | |
| 101 | 26/07/2017 | |
| 101 | 25/07/2017 | |
| 101 | 23/07/2017 | |
| 102 | 26/07/2017 | |
| 103 | 27/07/2017 | |
| 103 | 25/07/2017 | |
| 103 | 24/07/2017 | |
| After sorting data by id and date (in knime I stopped at this point) with excel if i insert formula = IF (A2 = A1; C1 + 1; 1) into cell c2 i get an id counter. How can I get a similar counter adding new column with knime? Thank you for your time. Walter. |
||
| id | data | cont |
| 101 | 27/07/2017 | 1 |
| 101 | 26/07/2017 | 2 |
| 101 | 25/07/2017 | 3 |
| 101 | 23/07/2017 | 4 |
| 102 | 26/07/2017 | 1 |
| 103 | 27/07/2017 | 1 |
| 103 | 25/07/2017 | 2 |
| 103 | 24/07/2017 | 3 |