Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

Add CountEmpty - CountNotEmpty as Summarize option

Currently if I receive a file where fields are empty rather than Null(), the summarize won't count them with the CountNull option. Fairly easy to put a formula right before when there is just a couple of fields and change with an IF IsEmpty() but with a file with a large number of fields and large file size, a multiple field tool eats up a lot of time converting.  Not sure if it would just be trading processing speed in the summarize to do basically the same thing.
2 Comments
Ned
Alteryx Alumni (Retired)
It's already in there in the string category of the Summarize tool.  Maybe not the most consistent naming - its called "Count Non Blank"
brian_wiedower
6 - Meteoroid
Thanks Ned.  That's exactly what I was looking for.