Filter data table activity to remove empty rows

Help Studio
, , ,
1

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.

Sheet
Sheet1634×919 78.4 KB

not
not1913×959 111 KB

2

Hi @darshanb.is22

Can you provide the excel?

Regards

1 Like
3

@darshanb.is22

Just give 0,1,2,3 that should be enough

And I hope ypu want to filter empty rows

Cheers

1 Like
4

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.

5

Data.xlsx (15.3 KB)

1 Like
6

@darshanb.is22

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
7

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
8

Hi @darshanb.is22

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 :slight_smile:
Cheers!!

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.