How to apply more than one filter on a single column?

Learn Academy Feedback
1

I have tried it using Excel Application Scope but it’s getting only one filter on a single column and i want to apply more than one filter on that single column. Anyone help me out. Thank You.

2

@Harsh95

Welcome to the UIPath Community.

Could you please tell more details about the issue.

     yourDT.Select("[Column1] = 'Value1' AND [Column1] = 'Value2'...").CopyToDataTable

And also you can use Filter DataTable activity to do this.

3

Hi @Harsh95,

You can do this with filter data table activity. Just add the column name and the conditions to filter.

4

Ya , I got it. Thank you for your help.

1 Like