Eliminating rows from file when each column is 0.00/null

Question

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

Text Input FIle.xlsx

Tesing - Eliminating Rows.yxmd

KevinHarrison · Accepted Answer

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