How to exclude 1 specific value from an excel table column using filter table activity?

Help
1

Hi guys…
Suppose i have an excel table for a column called “closed” and i have to uncheck only the value “test” from this column using filter table activity.
In filter options i have tried giving this code:
{“<>test”}
But this is throwing an error “range does not exist”
Please help me out.
Thanks.

2

700×373 54.8 KB

This image is just for reference.

In the image, for the Column, give “closed”
In the image, for the Operation, select !=
In the image, for the Value, enter “test”

3

hi karthik…thanks for the reply.
what you’re showing here is for filtering datatable.
what i want to do is filter excel table directly.

4

I am confused. Let me check with excel table.

6

Hi Dheeraj,

I have looked into this. But currently we do not have an option to exclude a value using filter table activity.

By following the below approach we can achieve.

  1. Use Read Range Activity to read the Closed Column values.
  2. Delete the row containing “test” from data table using Select or Filter Data Table Activity
  3. Convert the first column of Filtered Data Table to Array
  4. In the filter Options of Filter Table, give this Array.

Regards,
Karthik Byggari