Is their a tool in Alteryx that will suppress zeros before you output the data to a file?
Solved! Go to Solution.
What do you mean by suppress? Are you looking at zeros as values for particular columns and want to null them out?
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.
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.
Thanks, that was the answer.