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?
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.
