The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Expand the default filter with extra option.

Is it possible to expand the filter function with an extra option to select a field with a filter definition in it. I want this so i can define a filter over multiple fields an type.

 

Alteryx filter.png

I saw that Carlos has made a similar macro (Click here).

 

To execute a filter saved in a record set i now have build a macro. this is how my macro looks like. nothing fancy but it does his job. 

Filter Macro.PNG

the macro is then called like this:

Filter Execution.PNG

regards Humberto

5 Comments
SeanAdams
17 - Castor
17 - Castor

Hey @kelkboom

 

I believe you can do exactly what you're looking for, using a Dynamic Replace with a filter immediately following it.   Dynamic Replace is able to push in and evaluate a formula as you're asking for.    Not saying we shouldn't extend the filter tool, but just that you may have a way round this using existing tools.

 

Have a look at the help - there's a specific example that you can copy that does this.

 

You can find it in the help hereYou can find it in the help hereThe first example does what you are looking forThe first example does what you are looking for

kelkboom
7 - Meteor

Sorry for my late reaction, Yes It works. Changed it a bit and got it working

Thnx Humberto
result Dynamic replace.jpg

Community_Admin
Alteryx
Alteryx
Status changed to: Inactive
 
Community_Admin
Alteryx
Alteryx

The status of this idea has been changed to 'Inactive'. This status indicates that:

 

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

patrick_digan
17 - Castor
17 - Castor

While the dynamic replace can help in situations like this, it would be great if the functionality were built right into the filter tool!