Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Count Nulls by Grouping columns

GaRaGe
8 - 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?

2 REPLIES 2
LordNeilLord
15 - Aurora

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

BenMoss
ACE Emeritus
ACE Emeritus

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