Hello Evenryone, Is there any way to add index column in the datatable and then incrementing row values in added index column by 1, Input DataTable: Order Number Name City ID Order Amount 894626 John Singapore STDX-11 ₹ 23,121 893610 Kenrick London STDX-12 ₹ 33,908 893077 Tim New York …

Hi @NILESH.BOT369 → Build Data Table [MicrosoftTeams-image (1)] Output-> outputDataTable → Read Range Workbook [MicrosoftTeams-image (2)] Output-> dt → Use Below syntax in Assign: outputDataTable = (From row In dt.AsEnumerable() Let indexValue = dt.Rows.IndexOf(row) + …

@NILESH.BOT369 YourDataTable = YourDataTable.AsEnumerable().Select(Function(row, index) row.ItemArray.Concat({index + 1}).ToArray()).CopyToDataTable()

HI @NILESH.BOT369 Assign activity: outputDataTable = (From row In inputDataTable.AsEnumerable() Let indexValue = inputDataTable.Rows.IndexOf(row) + 1 Let orderAmount = Convert.ToInt32(row("Order Amount").ToString().Replace("₹", "").Trim()) Se…

@NILESH.BOT369 if you have a build datatable activity having all the columns names try this once dt.AsEnumerable().Select(Function(a,i) dt.Clone().LoadDataRow({(i+1).ToString().Concat(a.ItemArray).ToArray()}, False)).CopyToDataTable()

we can avoid the LINQ and achieve it by: Build DataTable - Configure an empty DataTable with 1 Col - RowNum, Configure AutoIncrement [grafik] dtMarked Then use a Merge DataTable Activity and merge your DataTable into dtMarked

thank you, But what if i dont know how many rows are there in the “dtMarked”? Because we have to add those many rows in Build Data Table manually?

no, you dont have to place any row in dtMarked: [image] ppr: Configure an empty DataTable was also mentioned: when merging dtData into dtMarked the autoincrement will be fired and the rownum is automatically set/ increased

Hello, if datas are not already in dataTable, I would go for an auto-increment new column. If datas are already there, i would stay simple with standard activities, not with linq for this purpose. Add Data Column for IndexValue For each row in datatable with currentIndex as output variable. And…

Got it, thank you, But, in this case “RowNumber” values will start from 0 when autoincrement will be fired.

we can set the start value by: Assign Activity: dtMarked.Columns("RowNum").AutoIncrementSeed = 1 do it before the merge datatable [image] DataColumn.AutoIncrementSeed Property (System.Data) Gets or sets the starting value for a column that has its AutoIncrement property set to true. …

Adding Index Column in DataTable using LINQ

Help Studio

ppr (Peter Preuss) February 20, 2024, 11:09am 5

we can avoid the LINQ and achieve it by:

Build DataTable - Configure an empty DataTable with 1 Col - RowNum, Configure AutoIncrement

dtMarked

Then use a Merge DataTable Activity and merge your DataTable into dtMarked

Datatable, Excel, RowNumber

Forum Engagement Daily Reports

Topic		Replies	Views
Linq - How to add anew column with row index to datatable Studio linq	3	3304	February 11, 2022
How to Auto Increment Datattable using linq Query Iam having 10k rows so for loop not possible Studio datatable , excel , uiautomation , activities , studio	3	2737	July 16, 2021
Datatable, Excel, RowNumber Activities excel , activities , question	3	206	April 9, 2024
Adding new row in multiple index of data table Studio uiautomation	11	119	April 19, 2025
Create Custom Index for Uipath Studio excel , studio	6	1050	December 16, 2022

Adding Index Column in DataTable using LINQ

Related topics