Adding new column with ordinal number of rows

KNIME Analytics Platform
1

Hi

I would like to add column with number of rows, but the number of rows is still changing, so there is no limit. It should depend from actual number of rows.

Just

A1 1
A2 2
A3 3
A4 4

Some time ago there was a nodepit, but I can’t find it now.

If anyone has an idea how to help me, I will be grateful.
Thanks

2

Hi,
I think you are looking for the Counter Generation node. Alternatively, you can use the Math Formula node and as expression just add the placeholder for the row index and add 1.
Kind regards,
Alexander

4 Likes
3

Alternatively use moving aggregation and count as aggregation type
br

1 Like
4

Thanks a lot! Your solution solved my problem.

5

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