Alteryx Designer Ideas

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

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

Submission Guidelines
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

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

16 Comments
Alteryx Certified Partner

@venkatmurugan  nobody can, as of yet...

its just an open proposal

Moderator
Moderator
Status changed to: Coming Soon

Thank you for your feedback and idea! Our product team was able to revisit this idea and include it in a upcoming release! We'll update this idea again once the release is available for download.

Alteryx Certified Partner

That's Wonderful !!!
Thank you

7 - Meteor

Thats some real good feedback!

Thanks for the efforts.

Alteryx Partner

nice work.  thanks.

Moderator
Moderator
Status changed to: Implemented

Thank you for your feedback and idea!

 

Delete Null Rows and Delete Null Columns has been added to our Data Cleansing tool in the latest release, 2020.2, which you can download here! Please note there is a order or operations when for these features where the tool will check and delete null rows before null columns should both be checked. Be sure to let us know what you think in the Designer Discussions board!