Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Remove Empty Rows

8 - Asteroid

For example, I have 10 variables and 1000 rows.


If one of the variables is blank, then delete this row.


Is it possible to do it in Alteryx? Thank you.

16 - Nebula
16 - Nebula

The simplest way is to use a Filter Tool with a custom expression, something like:


	IsNull(VarA) OR
	IsNull(VarB) OR
	IsNull(VarC) OR
	IsNull(VarD) OR
	IsNull(VarE) OR
	IsNull(VarF) OR
	IsNull(VarG) OR
	IsNull(VarH) OR
	IsNull(VarI) OR

The true output (T) will be the rows to keep.

Alteryx Certified Partner
Alteryx Certified Partner



I'm too lazy for that!  I would first transpose the record (keep the key or creat a recordID for a key).

Then I would filter for IsNULL([Value]).

Then I would JOIN to the original data and keep the L (assuming that the R side of the join came from the True Filter of Null values)


Anything with a Null variable would be excluded.


More tools, but less formulas.....



Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
16 - Nebula
16 - Nebula

I vary between the two.

As long as you have a decent text editor to handle that expression very easy to write.

That said first thought was your way just slightly simpler to do the other when starting out with a workflow.

7 - Meteor

Solved, interesting challenge, the fourth one needed more steps