Suppress Zeros

[cstafford]

Is their a tool in Alteryx that will suppress zeros before you output the data to a file?

[mbarone]

What do you mean by suppress?  Are you looking at zeros as values for particular columns and want to null them out?

[MarqueeCrew]

@cstafford,

If a TEXT field starts with leading zeros, you can:

TrimLeft([Field],"0")

That turns 0000123 into 123.

Cheers,

Mark

[cstafford]

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.

[mbarone · Accepted solution]

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.

[cstafford]

Thanks, that was the answer.

[mbarone]

Glad to hear it!