In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

delete null rows and columns

Prakash_Kumar
7 - Meteor

Hi,

 

Option to delete null rows or columns from the data. Just wanted to share with everyone.

 

Thank you

4 REPLIES 4
smoskowitz
12 - Quasar

@Prakash_Kumar 

 

Thank you for sharing. That functionality is also built right into the Data Cleansing tool. More options are always better.

 

Regards,

Seth

 

 

smoskowitz_0-1618860015262.png

 

NiravParikh281
6 - Meteoroid

Hi,

 

i dont see the option of removing null rows or columns. do i need to do anything to have them reflected

 

NiravParikh281_0-1625327931552.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @NiravParikh281 

 

It is present from version 2020.2.

Prakash_Kumar
7 - Meteor

Hi @NiravParikh281 

 

This is macro and if you add this macro after your data, you will be able to see the option to delete blank rows or columns.

 

Prakash_Kumar_1-1625486180182.png

 

This feature is we have in 2020 version but if you're using 2019 version this gonna help you in data preparation.

 

Thank you

Labels
Top Solution Authors