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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Count Nulls by Grouping columns

Asteroid

I have a data that looks like this

 

groupvar1var2var3
1  0.9
10.5  
1   
2 0.70.5
2   
20.8  
3   
3   
3 11

 

I need to count the number of nulls under each group and publish it in below structure

 

 nulls_group1nulls_group2nulls_group3
var1223
var2322
var3222

 

How can i do this in Alteryx?

Highlighted
Alteryx Certified Partner

Hey @GaRaGe

 

This should give you the answer you are looking for:

 

CountWithNulls.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Alteryx Certified Partner
Alteryx Certified Partner

Hi.

 

Transpose your dataset, the key field will be you group field, and your data fields will be your variables.

You can then do a summerize, and count null option, grouping by both your new [name] field generated by the transpose (this is just the variable field names) and also your group field.

You can then crosstab your data back into your desired output format.

 

Attached is an example.

 

Ben

Labels