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

Alteryx designer Discussions

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

Remove Null Valued Columns

Highlighted
Alteryx Partner

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!

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. 

Labels