Filtering data from datatable using linq command

[syris]

need to filter product column that is having only nokia mobiles

[copy_writes (chethan)]

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

Regards
Chethan P

[NIVED_NAMBIAR (NIVED N)]

Can u share the screenshot of your excel data?

[Ganesh_Preetam_Kopparapu (D3XT3R_)]

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