Email tool display # of rows written

I have a job that writes data using an output. Upon completion of the workflow I have it set to send an email from the events. Is there a way to include in that email only the number of rows that were written in the output? All I want the email to say is "xx number of rows were written".

Thanks in advance.

Events

Accepted answers

Claje

Hi,

Instead of using the Email event, you can set up a Block Until Done tool before your output. Connect your Output Data tool to the "1" outgoing connection. Then, connect a Count Records tool to the "2" outgoing connection, and connect an Email tool to this. You may want to use a Formula tool to create your email.

All comments

Claje

Hi,

CharlieS

In the workflow configuration, you can set up an event to send an email upon workflow completion. That email will include the results log in the body by default (referenced as "%OutputLog%"). The output log will include the information for "xx number of rows were written", but it cannot be filtered to only show this information.

Event Email Log Output.png

raghusrealm

Hi,

I am just curious if you have a answer to your question. How to get email tool to display # of rows written in the body of the email.

If you could share the workflow that would be very helpful.

thanks

Raghu

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703