Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
21 - Polaris
21 - Polaris

@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