BuildData Table_002

[Gokul_Murali]

This is a data table

i want to add value to 2018 as first row
now i want to add value to 2019 to the same first row

how can i achieve this.

[Harsha_Raj]

Use Add Data Row activity
In Array Row pass {“2018”, “2019”}

[Gokul_Murali]

@Harsha_Raj

I have used in 2 different if condition so it is giving the value in 2 different rows

[Harsha_Raj]

Use row index to update the value
dt_Variable.Rows(rowIndex)(ColumnIndex OR ColumnName) = Value

[Gokul_Murali]

@Harsha_Raj

I have 2 question

     1. Do i need to hardcode this rowindex Value?
     2. So after assigning which activity should i use write range

[manasrlenka25 (Manas Lenka)]

Use the LookUpDataTable activity to find the row index based on a value, then use that index to update the row. Refer to the activity’s documentation for more details.

Example:

dtTest.Rows(2).Item(3) = Value