Filtering data from datatable using linq command

need to filter product column that is having only nokia mobiles

1 Like

It was verry easy

Use this bellow code
Using Assign Activity (DT1) is op variable of Data table (Read Range)

Dt1=Dt1.AsEnumerable.Where(Function(r) r.Item("Productcolumn").ToString.ToLower="nokia").CopyToDataTable

If you get solution Please mark it as solved

Chethan P

1 Like

Can u share the screenshot of your excel data?

(From row in datatable1.AsEnumerable() Where(row.item(Columnname).tostring.Equals(“Nokia”)) Select row).CopyToDatatable