Start Free Trial

Alteryx Designer Desktop Discussions

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

Remove null cells across multiple fields

Chirag_KRCPL
8 - Asteroid

Given below is the data:


Chirag_KRCPL_0-1662100230500.png


Requirement : I want to delete entire row ONLY if data in ALL the FIELDS is NULL.


So based on above requirement, I want to delete only row 4. And hence, I expect the below outcome:

Chirag_KRCPL_1-1662100294972.png


Kindly help me with a solution.

Thanking in advance!

Regards,
Chirag

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@Chirag_KRCPL,

 

Please see below :

 

messi007_0-1662100995508.png

Attached the workflow,

Regards,

Sebastiaandb
12 - Quasar

Hi @Chirag_KRCPL ,

 

Make a filter tool behind your input and add the following expression:

 

[MV]!= Null()
OR
[Price] != Null()

OR
[Quantity] != Null()

 

Greetings,

 

Seb 

Sebastiaandb
12 - Quasar

Lol @messi007 way is easier i guess haha ;-)

Labels
Top Solution Authors