Alteryx: How do I easily remove a record/row that only has null columns????
Question ID:
109852
| ♥ 0 |
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?
Thanks!
Marked as spam
|
Posted by 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. Attachments:
Marked as spam
 Posted by Captain Tester (Questions: 0, Answers: 17) Answered on October 1, 2020 9:41 am
|
