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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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

6 Comments
Quasar
Quasar
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.

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.

Totally agree adding this option.

Atom

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

Labels