Help needed with filter data table

I’m using a filter data table to filter a condition which is optional so how to check if the column has certain keywords and then filter?

I tried this

It doesn’t seem to be working as expected

Kindly help

1 Like

@Palaniyappan na

Hi @cybzom
you can do the filter not only with filter datatable activity
use assign activity
Dt1=DT.Select(“[ColumnName]=‘your desired value’ or [ColumnName]=‘Desired value’”).CopyToDatatable()

Ashwin S

1 Like

We can use this expression
dt = dt.Asenumerable().Where(Function(a) a.Field(of string)(“yourcolumnname”).ToString.Contains(“your keyword”)).CopyToDatatable()

Cheers @cybzom

1 Like

@Palaniyappan its showing value of cannot be converted to boolean

1 Like