One Star

Get row count from Excel File

Hi All,
I have a job where I am sending an email with Excel file attachment, with "Don't Generate Empty File" checked and also "Include header" checked. This causes the file to send out an empty file with only headers.
I am aware that this is most likely the intended behavior of the code.
I would like to use a tool to count either the tParseRecordSet or the tFileOutputExcel and if rowcount = 1, send a separate email.
Any assistance is appreciated.
2 REPLIES
One Star

Re: Get row count from Excel File

Hi, did you try
((Integer)globalMap.get("tFileOutputExcel_1_NB_LINE")) ?
One Star

Re: Get row count from Excel File

I have not tried that. I am new to Talend, how would I implement that?