Insert a value in DataTable

Help Studio
, ,
1

hello,

Is it possible to insert a value to a specific cell in datatable without using an integer as the index of the row → but instead, using the row name?

for exemple-> DT.rows(“b”).item(“Type 2”)?

image

2

I’m not sure how to do that without the index but if you want it to be dynamic I suggest you do it like this:

image
image608×618 13.5 KB

Where Update Value is:

image

Hope this helps.

3

@Lior_Ben_Naim

You need index to update the value

You can check below for your reference

reference

Dt.Rows(Index).Item(“ColumnName”) = YourValue

Hope this may help you

Thanks

4

Hi,

You will have to get the index for row to update the value.

It can be done by using Lookup Datatable activity. You can pass the following arguments.
Datatable → Your datatable variable
Lookup Value → the value of row that you will searching. So if the value if you want to update type 2 for list value b, you can assign b.
ColumnName → “List”
In the Output Properties, RowIndex-> Here, you can store the returned rowindex in the variable
So, after this activity you will have the index.
You can use this index to update the type2 column.
Use assign with
DatatableName.Rows(IndexofRowReturnedbyLookupDT)(“type2”) = “your type 2 value”

Hope this helps

5

in_dt_Src.AsEnumerable().Select( Function(r) r.Field(Of String)(in_str_Search_ColName) ).ToList().FindIndex( Function(col) col = in_str_Search_Value )