Serial number adding coloumn

I need to add a data column of serial number at the end after data scraping with specified sheet names as shown in the excel attached.
sample.xlsx (9.9 KB)

1 Like

Yah we can use ADD DATA COLUMN Activity
—mean while in the variable panel create a variable of type int32 named serial_number with default value as 1 defined
—now in the ADD DATACOLUMN activity where in the column name property mention this serial_number.Tostring variable
And in the datatable property mention the name of the datatable that we obtain from read range of the excel

Hope this would help you
Cheers @Karthik_Kulkarni