Hi, I’m very new to Knime so am familiaring myself with the functionality based on how I’d use other tools (such as Excel or Alteryx to achieve the same result).
One thing I am struggling with is to create a multi-row formula with reference to itself.
For example, I have the following data:
| Col A | Col B | Counter |
|---|---|---|
| A | 1 | 1 |
| A | 1 | 2 |
| A | 1 | 3 |
| A | 1 | 4 |
| A | 2 | 1 |
| A | 2 | 2 |
| A | 2 | 3 |
| B | 1 | 1 |
| B | 1 | 2 |
| B | 1 | 3 |
| B | 2 | 1 |
| B | 2 | 2 |
Columns A and B already exist, and I want to create a running counter for how many of each there are. So, for example, there are four lines with A 1 in the first two columns, so I want to assign the first line with 1, then 2 etc.
Have tried searching previous topics without much luck, so hoping someone can point me in the right direction. Thanks for any help!
