Suppress Zeros
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is their a tool in Alteryx that will suppress zeros before you output the data to a file?
Solved! Go to Solution.
- Labels:
- Interface Tools
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What do you mean by suppress? Are you looking at zeros as values for particular columns and want to null them out?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If a TEXT field starts with leading zeros, you can:
TrimLeft([Field],"0")
That turns 0000123 into 123.
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, that was the answer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator