Alteryx designer Discussions

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

Remove Empty Rows

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

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

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
Meteor

Solved, interesting challenge, the fourth one needed more steps

Labels