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!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Data Cleansing Tool -> Delete Null Rows & Columns

There are few workarounds for this task, but it would be really very easy if Data Cleansing Tool could delete Null Rows and Null Columns. After all its just a macro which can be modified and re-packaged into Alteryx Designer.

 

Currently, to delete a null row requires multiple columns validation for common Null attributes,

similarly to delete a null column every column has to be compared on a row-level and flagged for removal. Both of these approaches are clumsy.

 

Wouldn't it be so simple if Data Cleansing Tool gave such check boxes !!!

 

Untitled2.png

 

 

Untitled.png

23 Comments
rajkrovvidi
6 - Meteoroid

How to add the workflow ? I couldnt find the attachemnt upload button here. I copied the code above. You can save it as .yxmd file and it will run. 

alust
5 - Atom

+1 person who would like this feature

KylieF
Alteryx Community Team
Alteryx Community Team

Hi @alust, this feature was included back in the 2020.2 version of Designer and is present in all versions of Designer newer then 2020.1.

 

However if you or any other users are having trouble with the feature be sure to post in our Designer Discussion board area as that's the best place to attach and troubleshoot workflows.