Read count once output file is generated

Question

Hi,

I am extracting data from a database and saving data as an Excel file. I need to send the email with the source record count and no of records count from the output file. I am able to get the source count but can you plz help me how to get the record count once the file is generated?

binu_acs · Answer

@code2data you can use the Block Until Done tool and connect output tool and the record count tool

code2data · Answer

Hi DavidSkaife  and binuacs:

Thank you for your input. I am aware of the record count tool, as marked in below screenshot I want to find the count of the records in the file generated as output

binu_acs · Answer

@code2data as @davidskaife suggested you can add a count record tool like below

mail_recordcount.yxmd