How can we generate a sequence of 1 to 25 in a row.

[rohit782192]

I need a sequence in 1 to 25

17
NULL
NULL
NULL
1
2
NULL
NULL
5
NULL
7
NULL
25

[binuacs]

@rohit782192 Add a record id tool

[DavidP]

Hi @rohit782192 

While the RecordID will work if your 1st number is 1, a more general way to generate a range of numbers between the smallest and largest number in a set would be to find both the minimum and maximum number and then generate the numbers in-between.

Here's an example with the Summarize and Generate Rows tools: