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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels