Analytic apps to filter a keyword from all columns

[Gamaliel]

Hello Alteryx Enthusiasts and Experts,

I am trying to filter number 3 from all columns using only 1 filter tool. Afterwards, I want to connect an interface tool (text box) to input a keyword. The textbox tool must detect or filter number 3 from all of the columns.

I made my own configuration but still gave rows which do not have 3. Please see attached for the app.

Thanks.

[atcodedog05 · Accepted solution]

Hi @Gamaliel 

Here is something you can do which might be helpful to you.

Workflow:

You can directly use interface tool value in the filter tool. This will help you in your filters.

Hope this helps : )

[Gamaliel]

Can I use this textbox tool to filter number 3 from all columns at a time? I want to get all the rows with number 3 regardless of column it is located.

[Gamaliel]

Thanks. This is already enough 🙂 I will just have to mention all the columns in my filter tool.

[atcodedog05]

Yes 🙂 

Happy to help : ) @Gamaliel