Count Nulls by Grouping columns

[GaRaGe]

I have a data that looks like this

group	var1	var2	var3
1			0.9
1	0.5
1
2		0.7	0.5
2
2	0.8
3
3
3		1	1

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

	nulls_group1	nulls_group2	nulls_group3
var1	2	2	3
var2	3	2	2
var3	2	2	2

How can i do this in Alteryx?

[LordNeilLord · Accepted solution]

Hey @GaRaGe

This should give you the answer you are looking for:

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[BenMoss]

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