Custom filter

[Mohanraj7393]

Hi All, 

I want to filter the word "no action" , How to filter that word alone in all 20 number of columns. 

[atcodedog05]

Hi @Mohanraj7393 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[Mohanraj7393]

I have 20 columns, All columns have only 3 words as below

1.No action

2.increase

3.reduce

Now I want all columns "No action" alone in T and  remaining two words in F anchor.

[atcodedog05]

Hi @Mohanraj7393 

Can you provide sample data it will be easier and faster for us to help 🙂

[Mohanraj7393]

Hi, 

Please refer the attached D E F G columns I need "no action" in filter tool T anchor other two words in F anchor.

Thanks in advance

[atcodedog05]

Hi @Mohanraj7393 

Are you looking for something like below. If not please provide the expected output.

Hope this helps : )

[Mohanraj7393]

Not like below I need to filter in all columns not only one column

[atcodedog05 · Accepted solution]

Hi @Mohanraj7393 

Here is how you can do it.

Workflow:

Hope this helps : )