How can I filter a DataTable?

Help
1

Okay, I want to filter a datatable with the Select method, the condition I want to put inside is that it filters values that are >= to my value how do I express that?

2

Hi @Christopher_Gomez,
Use datatable.select(your condition)

3

@christopher_Gomez

You can use like this
table.Select(“Size >= 230 AND Sex = ‘m’”)

4

Hi @Christopher_Gomez,

Dt.select("amount>=5000").CopyToDataTable()

Refer more in below post
DataTable filtering with expressions

Regards,
Arivu :slight_smile:

5

HI @Christopher_Gomez

Datatable.Select(“[ColName]>=Value”).CopyToDataTable

6

Thanks, for the help @Naveen_tg, @aman_sheik, @arivu96, @amaresan
I already solve the problem. :smile:
This is the expression I used
Datatable.Select(“NOT [columname]<17500”).CopyToDataTable

7

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