STRING MANIPULATION MATCH FORMULA

[Gabriel2020]

Good evening guys, how are you ?

I would like to perform a Count / Sequence. I would like to create a column that sees how many times that string has and number example 1, 2 I will send a photo below as it should be.

[elsamuel]

See this example:

Repeating a Moving Aggregation (What are the options)

Hi @Tyler I created a workflow repeat_moving_aggregation.knwf (20.7 KB). It doesn’t use a Loop node or Moving Aggregation node. I used the rank node to rank you rowś within every id. With the CounterGeneration node I keep the original input order as is. [moving_average] gr Hans

[denisfi]

Hi @Gabriel2020 ,

You can use a rank node for it too… restarting again when you have a new value/different.

I saw that the @elsamuel gave the answer for you but you can see other ways to solve the same problem.

Seeya,

Denis