Unanswered

Sequentially number rows using a formula

(1) Share

Report

Posted on by Alchemy

Hello,

I'm creating a CSV table with data for internal requests. Each line should have a number, starting at 10 and sequentially increasing by 10 i.e. [10, 20, 30, etc.], so that each record can be more easily referred to.

Is there a formula that can be added to the Value of the Item column, which provides the necessary functionality?

Kind regards,

Stuart.

2024-07-09_CSV Ta...

All responses (3)

Answers (0)

Chriddle 7,793 Super User 2025 Season 1 on at

Like (1)

Report
Re: Sequentially number rows using a formula

No need for an Apply to each, a variable and all the stuff that makes flows complicated.
Just make use of the function range() and add a new property with a Select:

Select

From

range(0, length(outputs('Compose')))

Map

addProperty( outputs('Compose')[item()], 'RowNo', mul( add(item(), 1), 10 ) )

Result:

Title,Score,RTime,RowNo Item 0,2000,12,10 Item 1,2001,11,20 Item 2,2000,10,30 Item 3,2001,9,40 Item 4,2000,8,50 Item 5,2001,7,60 Item 5,2000,6,70
Alchemy 41 on at

Like (1)

Report

Re: Sequentially number rows using a formula

Hi Shravan,

I'm yet to attempt this, but I'll try to get to it soon.

Thanks for your help.

Kind regards,

Stuart.
Shravan 128 on at

Like (1)

Report
Re: Sequentially number rows using a formula

Initialize Variable
Add an action to initialize a variable (Initialize variable).
Set the name to counter, type to Integer, and value to 10.
Apply to Each Loop
Add an "Apply to each" action to loop through your data.
Inside the loop, add the following actions:
Compose Action to Set Value
Add a Compose action.
Set the input to the value of the counter variable.
Create CSV Table Action
Add an action to create the CSV table (if not already added).
In the column where you want the sequential numbers, use the output of the Compose action for the value.
Increment Variable
Add an action to increment the variable (Increment variable).
Select the counter variable and set the value to 10.