In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Eliminating rows from file when each column is 0.00/null

ll98
9 - Comet

 

Hi Alteryx Family 

 

I have the following WF -- But I want to create a formula where it eliminates rows that show no values across the columns.  Attached is WF and test file

 

ll98_0-1620872102291.png

 

1 REPLY 1
KevinHarrison
8 - Asteroid

This is one to do it. Transpose, sum, if = 0 then it is blank, filter out. Then you join back to data flow.

 

KevinHarrison_0-1620875043831.png

 

Labels
Top Solution Authors