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

[jgiacomazzi]

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.

[messi007 · Accepted solution]

@jgiacomazzi,

what about this:

Let me know if this solve you're issue 🙂

Hope that helps,

Attached the workflow,

Regards

[clmc9601]

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!

[AngelosPachis]

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