Outputting the % of Null values in a column

Question

Hi all,

I'm working on a rather interesting use case at the moment and something I need to as part of this is output the % of Null values in a few columns.

I'm just wondering is there way to do this in Alteryx I have tried a few things but luck as of yet so any help is much appreciated.

Many thanks,

Dean

DataNath · Accepted Answer

Hey @Deano478, 2 approaches immediately come to mind here - one is more manual whilst the other is 'out the box'.

1) As you mention having multiple fields, first Transpose your data and then group by the [Name] field, using the 'Count' and 'Count Null' aggregations on [Value] and then you can just work out the percentage in a Formula tool:

2) Use the Field Summary tool which calculates this as standard under the '% missing' field. The 'O' output anchor gives a reporting output which you can then Output via the Render tool (showing the result in a Browse tool for the sake of demonstration).