[SOLVED] ROWNUMBER() in RapidMiner

New Altair Community Member
Updated by Jocelyn
Hello,
currently I m trying to get my whole ETL for a process in Rapidminer. I ve got a table (A &
like:
colA | colB | colC
A | 2 | 1
A | 4 | 2
B | 1 | 1
C | 2 | 1
C | 3 | 2
Is there a way to create column C in rapidminer? In MS SQL I can use Row_Number and Partition (http://msdn.microsoft.com/de-de/library/ms186734.aspx) . I found a way using Loop Values, but this is far too slow for a table with several 10ks of examples.
Regards,
Mario
currently I m trying to get my whole ETL for a process in Rapidminer. I ve got a table (A &

colA | colB | colC
A | 2 | 1
A | 4 | 2
B | 1 | 1
C | 2 | 1
C | 3 | 2
Is there a way to create column C in rapidminer? In MS SQL I can use Row_Number and Partition (http://msdn.microsoft.com/de-de/library/ms186734.aspx) . I found a way using Loop Values, but this is far too slow for a table with several 10ks of examples.
Regards,
Mario