Remove 0 from table into script

[pgalvezt]

Hello,

I have a table with 3 fields with many values they all has '0', what I want is remove them but filtered, because if i remove a 0 value the other field maybe can a value <> to 0,

So I need filtered all 0 in 3 fields and the remove them all this into the script.

I prepared an excel file for better comprehenssion,

Lines 2 - 6 - 9 were removed...

Thanks!

[el_aprendiz111 · Accepted solution]

Hi,

tmp:
LOAD id,
[money 1],
[money 2],
[money 3]
FROM
[..\..\Documents\Downloads\Example (1).xlsx]
(ooxml, embedded labels, table is [Table in script])

Where RangeSum([money 1],[money 2],[money 3])>0
;