Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Valentinas
Contributor
Contributor
‎2021-11-30 03:59 AM

tFileOutputExcel

Hi,

I`m trying to append the existing MS Excel via tFileOutputExcel function, but this function overwrites this file (all sheets are deleted, and only new sheet left)

Append existing file is checked.

What I am doing wrong?

Thanks

Val

Labels (2)
Labels
72 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2021-12-01 01:45 AM

Hello,

"Append existing file / Append existing sheet" options mean you want to write at the end of the file / sheet if it exists.

Carefully, if you try to push data to the same xlsx file to 2 different sheets in the same subjob, you'll lost the 1st one.

You could write into multiple sheets without having to use multiple subjobs.

Better to write to a tHash and then write the results to the Excel file in subsequent sub jobs.

Best regards

Sabrina

72 Views
0 Likes