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
12 - Quasar
12 - Quasar
7 - Meteor
Can you ask the developers to add the new checkboxes per the original request? Would be a lot easier for new users.
Alteryx Partner

i agree with hdtruong.

7 - Meteor

I agree, adding an option to delete the rows where a field contains a null would be extremely useful. 

 

i.e., if any row that has a 0 in the amount column, that row then gets deleted.

5 - Atom

Totally agree adding this option.

5 - Atom

Here here. This would be a great add for data cleansing.

5 - Atom

This would be so helpful!

7 - Meteor

Hope the Alteryx Developers are working on this issue already. I just solved same problem using a filter tool, but this is only practicable for tables with few columns. The gymnastic with transposing and re-joining is likewise clumsy, we truely need the checkboxes in the cleansing Tool.

Alteryx
Alteryx
Status changed to: Revisit
 
5 - Atom

i am not able to see last two column