Alteryx: How do I easily remove a record/row that only has null columns????

Question ID: 109852

I have a large dataset that contains a select few records/rows that are null in every column. I would like to quickly remove these records, but I can’t just filter on one particular column because there are some null values in records that also have data. Is there a way to quickly remove these entirely null records?



Marked as spam
Posted by (Questions: 16, Answers: 0)
Asked on September 30, 2020 11:18 pm
Answers (1)
Private answer

In the past, this could be accomplished by doing a series of pivots and using the filter tool. However, in a recent version update, the Data Cleansing Tool was tweaked to accomplish this exact task.

Simply drop a Data Cleansing Tool onto your canvas, then, in the configuration window, select the top box which says 'Remove null rows'. This was a great update from Alteryx and makes this process way easier.

Hope that helps.

Marked as spam
Posted by (Questions: 0, Answers: 16)
Answered on October 1, 2020 9:41 am