Update data row

Help Activities
, ,
1

Hi All,

I have a data table with multiple columns. There could be any number of rows.

Logic: I have to get the value of each row for “Column 4”, very if the value contains “some number” in there and update “Column 9” saying “Numeric value exists”.

How can I achive that?

2

Hi @Krithi1

Can you try the below

The image depicts a sequence of tasks in an automation workflow, including reading a workbook, invoking a code to process the data, and writing the updated data back to the workbook. (Captioned by AI)
The image depicts a sequence of tasks in an automation workflow, including reading a workbook, invoking a code to process the data, and writing the updated data back to the workbook. (Captioned by AI)848×572 30.8 KB

This image shows a dialog box labeled "Invoked code arguments" with a DataTable argument named "dt" set as both input and output. (Captioned by AI)
This image shows a dialog box labeled "Invoked code arguments" with a DataTable argument named "dt" set as both input and output. (Captioned by AI)882×254 8.77 KB

Code:

dt.AsEnumerable().ToList().ForEach(Sub(row)
    If System.Text.RegularExpressions.Regex.IsMatch(row("Column 4").ToString(), "\d") Then
        row("Column 9") = "Numeric value exists"
    End If
End Sub)

Regards,