community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Quick Count of Null and Distinct Values of each field

Highlighted
Alteryx Partner

Hey,

 

I have also made a macro which can give quick count on the null values as well as distinct values for each field. This will be really helpful if the number of attributes are high and going for the browse tool to check each and every field is hectic!

 

*Blank fields are also treated as 'Null'.

Thus, if a string field is empty but having spaces in it, it would also be treated as 'Null'. 

PFB my Macro.

 

Cheers!

Labels