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.
Solved! Go to Solution.
what about this:
Let me know if this solve you're issue 🙂
Hope that helps,
Attached the workflow,
Regards
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