How to separate a whole column if one cell value is less than 5?

[Prijesh_J (Prijesh Jp)]

Hi All,

I have to task to separate a whole column if one cell value is less than 5 for eg:

In the before image if task point is less than 5 i need to get it in a data table variables

[Srini84 (Srinivas Kadamati)]

@Prijesh_J

Check as below

DataTable Variable = dt.AsEnumerable.Where(Function(r) CInt(r("Task points").ToString) < 5).CopyToDataTable

Check below for missing reference while using above LinQ query
https://forum.uipath.com/t/tutorial-check-value-exists-in-excel-sheet-using-uipath-part-3-without-using-foreach-loop-filterdatatable/247533/3

Hope this helps you

Thanks