How can I filter a DataTable?

Build
#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.