Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
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

Engine: Do not evaluate predicates where there are zero rows

In cases where there are dynamic tools - you often get a situation where there are zero rows returned - which means that the output of something like a transpose or a JSON parse or a regex may not have the field names expected.

 

However - any downstream filter tools (or other similar tools) fail even though there are no rows (see screenshot below).

 

The only way to get around this is to insert fake rows using a union or use the CReW macro for Ensure Fields.    However, this is all waste since there are no rows so there's no point in even evaluating the predicate in the filter tool.     Rather than making users work around this - can we please change the engine so that a tool can avoid evaluation if there are zero rows - this will significantly reduce the amount of these kind of workaround that need to be used with any dynamic tools (including any API calls).

 

thank you

Sean

 

 

 

 

 

Predicate.png

 

 

 
 

 

4 Comments
jarrod
ACE Emeritus
ACE Emeritus

The other solution i can see to this problem is having the ability to save a schema in a tool. @SeanAdams, Imagine being able to save an example API response to later be parsed when in dev mode... that saves on API calls and allows for faster iteration since you aren't hitting an external API just to get sample data downstream.  

patrick_digan
17 - Castor
17 - Castor

This is annoying to try and build around when it pops up.

TonyaS
Alteryx
Alteryx

Thanks @SeanAdams 

I wanted you to know that this has been added to our internal Intake for product ideas. 

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes