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: 
Anonymous
Not applicable

Unable to add new sheet in excel through Append to existing file option in tmap

Hi ,

I am trying to add multiple sheets to an excel file based on multiple output from tmap.

But i see that only 1st sheet is created and rest are not . Is it because the output flows running  manually? 

 

Please help me in creating multiple sheets into an excel from tmap.

Thanks,

Hachi

Labels (2)
2 Replies
TRF
Champion II
Champion II

You cannot address the same excel output file by different flows within the same subjob. So you need temporary files or tHashOutput for 2nd and following sheets then you will address them separately.
Anonymous
Not applicable
Author

It's possible append data to existing file in different sheet, there must be something wrong in your job design or component settings. Can you please share a job design and the component settings of tFileOutputExcel?

Regards
Shong