List column by group in Knime

Hi knime

I am starting to use knime, my problem is: I need to list a string for different groups

Table 1:
A1 A2
x1 N3
X1 N3
X1 N3
X2 N3
X2 N3
X3 N3
X3 N3
X4 N3
Y5 N3
Y5 N3
P6 N3
P6 N3
P6 N3

Result:
Table 1:
A1 A2 A3
x1 N3 1
X1 N3 2
X1 N3 3
X2 N3 1
X2 N3 2
X3 N3 1
X3 N3 2
X4 N3 1
Y5 N3 1
Y5 N3 2
P6 N3 1
P6 N3 2
P6 N3 3

Hi @fernando1987 -

You can use the Rule Engine to assign strings. The syntax is a little tricky at first, but look at this example to see how it works:

Hi @fernando1987

The Rank node is also a way to go. Mode: = ordinal


gr. Hans

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.