Read count once output file is generated

[code2data]

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?

[davidskaife]

Hi @code2data 

You will just need to include a Count Records tool (found under the Transform section) before your output tool. This will count the number of records passing through the data stream that you can then use elsewhere.

[binu_acs]

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

[code2data]

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]

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