Alteryx designer Discussions

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

Remove Empty Rows

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

Highlighted
16 - Nebula
16 - Nebula

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

 

NOT (
	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
	IsNull(VarJ)
)

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@jdunkerley79,

 

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.

Highlighted
7 - Meteor

Solved, interesting challenge, the fourth one needed more steps

Labels