Is their a tool in Alteryx that will suppress zeros before you output the data to a file?
Sounds like a Filter Tool would do it. You'd connect a Filter Tool right before your output, and filter on (no-hand + on_order) != 0 if you want to connect your Filter Tool to your Output Tool from the "T" node, or, equivalently, filter on (no-hand + on_order) == 0 if you want to connect your Filter Tool to your Output Tool from the "F" node.
What do you mean by suppress? Are you looking at zeros as values for particular columns and want to null them out?
@cstafford,
If a TEXT field starts with leading zeros, you can:
TrimLeft([Field],"0")
That turns 0000123 into 123.
Cheers,
Mark
I have a output file that includes store Id, article number, units on hand, units on order and if the total units (on-hand + on_order) equals zero, i do not want to show this line in the output.
