How to provide Serial No starting from 1

[Chippy_Kolot (CK)]

Hi,

I have a build datable there I provided one column as serial no, type as integer ,and I checked Autoincrement checkbox provided default value as 1. But serial no is taking from zero, How can I solve this.

[fernando_zuluaga]

Hi @Chippy_Kolot

What are ypu trying to perform? datatable always is zero index based, always will start from index 0

Regards!

[supermanPunch (Arpan)]

@Chippy_Kolot

But serial no is taking from zero, How can I solve this.

Hi @Chippy_Kolot ,

You could try specifying the First row value as 1, then when you add another row, it should automatically increment the value.

The Default Value is disabled when the Auto Increment is enabled, Hence I believe we will not be able to make use of it.

[ppr (Peter Preuss)]

@Chippy_Kolot

and I checked Autoincrement checkbox provided default value as 1. But serial no is taking from zero, How can I solve this

when using the autoincrement.

• assign nothing for this column when adding a new datarow (it will populate by its internal)
• use the autoincrementseed when starting by a particular index
  DataColumn.AutoIncrementSeed Property (System.Data) | Microsoft Learn

EDIT - added some visuals:

Setting the seed:

Adding data

Result:

[Vishnuraj_Pandiyarajan2 (Vishnuraj Pandiyarajan)]

Hi @Chippy_Kolot

U can try this way
Step:1 drag the Build datatable Activity
Step:2 Remove the Column_2

Step:3 Add new column

Step:4 set Default value as Zero

Step:5 Then enable auto increment checkbox

Then the auto increment value will consider from Zero like this

Thanks
VP