You can iterate over the rows containing “lalala” if you create a For Each activity (not a For Each Row) with the datatype set to System.Data.DataRow. You will need to iterate over DtData.Select("[ColumnName] LIKE '%lalala%'") to get the array of rows where your string is present, where DtData is your datatable, and ColumnName is the name of the column on which you’re searching.
Where it says “For each [Field] in [Field]”, that expression goes in the 2nd field. DtData.Select("[ColumnName] LIKE '%lalala%'") will return an array of datarows to iterate over.
@RPA3 Can you Check with this Statement :
If you need the Array of rows matching the condition use this :
DT.AsEnumerable.Where(Function(x)x(0).ToString.ToLower.Contains(“lalala”)).ToArray
if you need the Datatable with rows having matching condition use this :
DT.AsEnumerable.Where(Function(x)x(0).ToString.ToLower.Contains(“lalala”)).CopyToDataTable
@RPA3 What do you want to do after you have found the row you want, do you want to Update the other Columns or other operation or just Find those values and output it’s value?