Can't filter Blank data per datatable.select

Help Studio
, ,
1

I have one excel, i want to filter data contain blank use datatable.select, however, it does not work.

NonPOPayment-20220627140639.xls (58.5 KB)

TestSelectBlank.xaml (8.2 KB)

2

so @Lori

basically based on which column you want to exclude blank rows

3

As an example: H25 has a blank and is not empty: so “” will not match as the value is like: " "

4

@nikhil.girish “Expense Type”

5

As an alternate we can use LINQ

(From d in DTReport.AsEnumerable
Where d("Operating Unit").toString.Trim.Equals(OperatingUnitItem)
Let et = d("Expense Type").toString.Trim().ToUpper()
Where {"OTHERS", "FREIGHT - COD", "FREIGHT"}.Any(Function (x) x.Equals(et) OrElse String.IsNullOrWhitespace(et)
Select r = d).Count
1 Like
6

Thank you very much!

7

Hi @Lori

If you want to go with the Select method, try this

DTReport.Select("[Operating Unit]='"+OperatingUnitItem+"' and ([Expense Type]='Others' or  [Expense Type]='Freight - COD' or [Expense Type]='Freight' or [Expense Type] is NULL)")
8

@kumar.varun2

I test your expression and it works well, thank you, you are so kind! :+1: :+1:

9

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