topic tFileOutputExcel NB_LINE wrong in Talend Studio

tFileOutputExcel NB_LINE wrong

jftdarr — Sat, 16 Nov 2024 01:57:36 GMT

I have a job that logs rows written to a file output which I have used the ((Integer)globalMap.get("tFileOutputExcel_3_NB_LINE")) to capture. In the resulting file every time I try to capture the number of lines in the excel file it returns the correct number -1. For example if no lines were written it records -1, if 10 lines were written it records 9. I was able to address this by adding a t_log_row after the file output and reading the number of lines off of that but this is a less than ideal solution.

Re: tFileOutputExcel NB_LINE wrong

manodwhb — Wed, 05 Aug 2020 02:22:02 GMT

@Jeremiah Tamagna-Darr , can you check and one more time and that are you counting Header record as well when you say it 10? without header how may records it has process that number will return.

Thanks,

Manohar