Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesI 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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.