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.

Categories:

Building flows

2024-07-09_CSV Ta...

I have the same question (0)

All responses (3)

Answers (0)

Shravan 128 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Alchemy 44 on at

Like (1)

Report

Hi Shravan,

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

Thanks for your help.

Kind regards,

Stuart.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No