removing empty rows in a more efficient way

[AbdulBasit]

Hi there i was wondering if there is a more efficient way of removing empty data than this.

[PhilipMannering · Accepted solution]

Hi @AbdulBasit 

Yes, you can remove rows that have nulls in any column using the following method,

[estherb47]

Hi @AbdulBasit 

While you could put a custom filter that combines all of the empties that you want to find, this way is actually more efficient. Every time you filter, you're making a smaller dataset. So the next filter will run faster and so on.

Let me know if that helps

Cheers!

Esther

[estherb47]

@PhilipMannering , nice!! Did you check speed on both approaches?

[PhilipMannering]

@estherb47 Errrrrrr... that's a negative. .No doubt using a single filter is quicker. When we talk about efficiency though are we talking runtime or time to configure as many filters as there are columns? Only @AbdulBasit  knows.

[DavidP]

Hi @AbdulBasit 

The advantage of the IsEmpty() statement in filters is that it checks for both nulls and empty cells (that are not null).

If your cells are definitely null, you can use the feature in Alteryx versions 2020.2 and newer in the Data Cleanse tool to remove null rows. I haven't checked if it also works for empty rows.

[AbdulBasit]

for a data set having to many columns this is more efficient other wise the canvas would get messy and if we have 50 colums lets say it would not be a good idea to add 50 filters.

[AbdulBasit]

for a data set having 50 colums i think this would be efficient. Tell me if we have 50 columns and we want to remove nulls from them will this method work without adding any other tool.

[AbdulBasit]

Can you show me the way.

[atcodedog05]

@AbdulBasit 

@PhilipMannering workflow should work for n (even 50) columns.