Increment each row in a column based on starting value in the column

I know I can produce the following output using the Multi-Row Formula tool.

1

2

3

4

5

I'm wondering if I could do the same with a different starting value, changing

60

60

60

60

60

to

60

61

62

63

64

Is there a way to do this with the Multi-Row Formula tool or a different tool? I've also tried using Tile, which didn't help.

Datasets

Accepted answers

what about this:

Let me know if this solve you're issue 🙂

Hope that helps,

Attached the workflow,

Regards

Add20210119.yxmd

All comments

what about this:

Let me know if this solve you're issue 🙂

Hope that helps,

Attached the workflow,

Regards

Add20210119.yxmd

Yep, @jgiacomazzi, multi-row formula can do that!

Choose the option to set non-existing rows to the value of closest row.

Then use this logic: [Row-1:column name] + 1

Hope this helps!

Hi @jgiacomazzi ,

You can use both the multi-row formula tool or the generate rows tool to get what you are after here.

I would suggest the latter if you don't have an input, but it widely depends on your use case.

Regards,

Angelos

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703