Help needed with filter data table

[cybzom (Kiran Saminathan)]

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

Finding out if a value exists in a database column

Hello, my job is to scrap data from a webpage (it’s only 1 column), then check if a certain value (known earlier) exists in that table/column. Then, if this value exists, I have to perform one action and if it doesn’t - another one. Do you know how to do it? I tried with ExtractDataTable (output of data scrapping) then for each row, in Body - If Rows(“Column1”).ToString = DesiredValue. The problem is that it looks like it analyzes not if a value is in a table, but if rows are equal. It affect…

It doesn’t seem to be working as expected

Kindly help

[cybzom (Kiran Saminathan)]

@Palaniyappan na

[AshwinS2 (Ashwin S)]

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

[Palaniyappan (Forum Leader)]

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

Cheers @cybzom

[cybzom (Kiran Saminathan)]

@Palaniyappan its showing value of system.data.datatable cannot be converted to boolean