Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

How to clear filters on a column?

Highlighted
8 - Asteroid

If I set a filter on a column, how can I clear that filter?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @jonnyrask ,

 

you can clear your filter by clicking in the 3 dots and the x button after.

fmvizcaino_0-1592841335266.png

 

Best,

Fernando Vizcaino

 

Highlighted
9 - Comet

Hi @jonnyrask  - not sure what your use case is but you can always built different workflow stream from the tool before the filter that has 'unfiltered' data. If you share more details or be more specific, we can help.

 

pankajk_0-1592841384154.png

 

Highlighted
8 - Asteroid

I want to clear the filter in the Alteryx code, not done manually

Highlighted
8 - Asteroid

So the workflow that is below will be run with the initial data?

Highlighted
9 - Comet

correct, so the 'filter' stream will be having only 'filtered' data while the other stream where I built the formula will have all the data.

if you share your data/workflow than I can share more info or graphics.

Highlighted
9 - Comet

another way is to bring the union tool and combine "True" and "False" streams:

 

pankajk_0-1592842128983.png

 

Highlighted
Alteryx
Alteryx

If you created a filter using a Filter tool, simply removing the Filter tool and re-running the workflow will remove it. You can think of the tools as analytic processes that you are building onto one another. If you delete a tool, you no longer have that process in place.

 

If you filtered in the results window (by clicking on the three dots in the corner), you can click on the three bars and select Revert to Original.

 

echuong1_0-1592844158787.png

 

Labels