Im trying to use the filter datatable activity on data from data Scraping saved in an excel file but there is no change, i also tried using column name also.
1 Like
Just give 0,1,2,3 that should be enough
And I hope ypu want to filter empty rows
Cheers
1 Like
Yes i want to delete the entire row if any of the data is missing. I gave 0,1,2,3 but it did not work.
Data.xlsx (15.3 KB)
1 Like
If you want to remove if any of those are missing then you should select Or …not And…
Please change the same
Cheers
1 Like
Assign Activity
dtFiltered =
(From d in YourDataTable.AsEnumerable
Let hasEmpty = d.ItemArray.any(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.Trim))
Where not hasEmpty
Select r = d).CopyToDataTable
In Filter Data Table Activity
Pass Only : 0,1,2,3 in Column
Note: Use OR Condition. Currently you are using AND
Hope it will helps you
Cheers!!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.