Alteryx Designer Discussions

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

Remove Null Valued Columns

maryas
8 - Asteroid

As part of a use case development, I thought of making this macro which would remove columns having null values. User can input the percentage of null values a column should possess in order to remove them.

 

I have attached the macro. I hope it might be useful for some of your data pre-processing.

 

Cheers!

2 REPLIES 2
BrandonB
Alteryx
Alteryx

Very clever! This can also be useful with Excel spreadsheets that have formatting in cells to the right of the normal data but no values in them causing additional columns to be read into a workflow with null values. 

ChrisPayne153
7 - Meteor

Great little process, thank you!  Did exactly what I was looking for.

Labels