Autonumber column in datatable based on number of rows

Help Activities
, , , ,
1

Hi,

Is there a simple way to add numbers in a column in a datatable, starting at 0 or 1, and then increment by 1 for each row that holds data?

So if there are 5 rows in the dt, a new column should show

1
2
3
4
5

2

@Evert_Randers

You want to create a datatable with one column and the number of rows you specified with a sequence of values

You can sue generate datatable with the following

"Column1" + Environment.NewLine + String.Join(Environment.NewLine,Enumerable.Range(1,varcount).ToArray())

And select newline as the row separator…so this creates a table with columnname as column 1 and will add rows from 1 to varcount…var count being a variable to which you can send the input number if you send 5 it adds 5 rows from 1to 5

cheers

3

Hi @Evert_Randers

Please find the following resource in which your requirements are met:

RowDataProcess.zip (147.4 KB)

Input:

image

Output:

image

Hope this helps,
Best Regards.

4

Hi @Evert_Randers

How about this expression?

dataTable.Columns.Add("ID", GetType(Integer))
For i As Integer = 0 To dataTable.Rows.Count - 1
dataTable.Rows(i).Item("ID") = i + 1
Next

This will add a new column named “ID” to your DataTable and fill it with numbers starting from 1 .

You can also use an Auto-Number System column to generate an automatically incremented counter for each row that contains data

Check out the thread

Regards
Gokul

5

Hi @Evert_Randers,

Try this workflow:
forum.xaml (7.4 KB)

Input:
image

Output:
image

1 Like
6

Thank you very much!

1 Like
7

Hi,

when using your solution in my workflow I get this error message:

ErrorCapture
ErrorCapture817×67 9.83 KB

8

@Evert_Randers

I thing you are using ‘Index’ with a caps I. can you check with ‘index’ as I declared a variable with small i?

Best Regards.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.