Need help with render tool to remove taxes with zero amounts

[Cat_H]

Hi Alteryx folks! 

I am running a flow where i have to generate one PDF per company, i have 20+ companies that each require a PDF to be issued and not all taxes apply to every company. Right now all taxes are appearing on each PDF even if the amount is zero. How can i dynamically remove any taxes that are $0?

I'm using the table + layout + render tool to generate these PDFs.

Here is the flow we're using:

Here is the current PDF example:

[DavidP]

Hi @Cat_H 

Can you not just put a filter tool in front of the Table tool to filter out rows with zero values?

[Cat_H · Accepted solution]

Disregard! we solved it by adding a filter for the taxes greater then zero after we transpose. 

[Cat_H]

LOL yeah, that's what we did essentially 🙂