This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
The true output (T) will be the rows to keep.
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.....
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.
Solved, interesting challenge, the fourth one needed more steps