Not able to filter Data table

HI.
I am trying to filter the Data table based on "Client " and “Patient”( Column “type”).
image

I have used Filter data table activity.
image

image

But in output its only writing headers.
image

Can someone guide me.

Hi @Dinesh_Babu_S ,

Could you use OR condition instead of AND condition and also check if any trailing spaces are there for Client and Patient. Please try and let us know. Thanks.

1 Like

Hi @Dinesh_Babu_S
Is it possible for you to upload your input excel

Hi @Dinesh_Babu_S ,

When you are comparing strings it is always advised to use .trim and either .tolower or .toupper

In your case, you can use. Filter Datatable activity supports the following expression

“Type”.ToString.Trim.ToLower = “client”
And
“Type”.ToString.Trim.ToLower = “patient”

This way you are explicitly telling covert column values to string, trim them and change cases only then compare the required string.

Dt.Select("Type in ('Client','Patient')").CopyTodatatable()
Or you can go head with @kirankumar.mahanthi1 answer.

Regards,
Arivu