Alteryx Designer Desktop Discussions

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

Removing rows with certain fields that are null

jt98
7 - Meteor

I currently have this problem. I want to remove the entire row if all the Value Fields are null (Bolded  rows), and keep the data if any of the Value Fields have values (ie. not null). 

jt98_0-1610421428080.png


The end result should look like this.

jt98_1-1610421454097.png


How should I go about doing this? Advanced thanks!

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

@jt98 
Hope this is what you need.

Appreciate if you would mark it as accept if you find it useful.

0112-jt98.PNG

_enrique_javier
7 - Meteor

Here's one solution.

 

Removing rows with certain fields that are null.png

 

Stay safe,

Enrique

Pronouns: he/him/his (https://mypronouns.org/he)

bradleyareese
5 - Atom

This worked for me Enrique.  Thanks!

Labels