Filter from Table tool

bubblyjai1982

Hi All

Need some assistance in filtering out the data / text in body of email.

I'm trying to generate the email with condition:

IF output contain trades >=50mm then respective trade (table) should reflect in body of email

And if there are no trades >= 50mm then it should give a output in Text i.e. "None"

Able to generate the email but not able to exclude "None" when there are trades >=50mm

In short the output "None" should filter out when there are trades >=50mm… currently i'm getting both output i.e. No. of trades >=50mm and "None"

For your reference I have attached my input file and workflow

Thank you in advance

Reporting Input 05172026.xls

Reporting Email.yxmd

OTrieger

@bubblyjai1982
Put a filter before the table tool and use another table tool so both streams will have the needed design.