Forum Discussion
AndersASorensen
3 years agoHelper I
Column value to rows
I would like to create a table with a count up to the column value.
So from this
| ID | Period |
| 1432 | 4 |
| 2342 | 2 |
To this
| ID | Period |
| 1432 | 0 |
| 1432 | 1 |
| 1432 | 2 |
| 1432 | 3 |
| 1432 | 4 |
| 2342 | 0 |
| 2342 | 1 |
| 2342 | 2 |
Hi,
you can add a custom column
{Number.From(0)..Number.From([Period])}
then Expand to new rows
and that's done
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
1 Reply
- serpiva64Solution Sage
Hi,
you can add a custom column
{Number.From(0)..Number.From([Period])}
then Expand to new rows
and that's done
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !