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

Filter Tool Basic Filter IsEmpty Not working correctly

I received a "string variable switched type" error on the filter tool performing a basic filter on the value column of "is not empty" after a transpose tool.  The value column is datatype of  V_String 255.  So even though the values are null, blank, number, text, it is all string as per the data type column flowing in.  When switching from basic to custom with formula: IsEmpty([value]) same error.   BUT, when using the Formula Tool to generate a new column for true/false there is no error. Also the Fitler Tool works as expected with IsNull on this dataset.

 

Please look into the isEmpty code in the Filter tool so that it behaves correctly.

 

Please note that pre-splitting the data with the isEmpty flag column using the formula tool, applying IsEmpty Basic Filter  to the True and To the False both worked without incident.  

 

What would be nice is if there is an error in the filter tool that it would output those to it's own stream.  Something like - True (T), False (F), Error (E).

Basic Filter Error.png