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