Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jftdarr
Contributor II
Contributor II

tFileOutputExcel NB_LINE wrong

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.  

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@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