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()

Thanks
Ashwin S

1 Like

Hi
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 system.data.datatable cannot be converted to boolean

1 Like