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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFileOutputExcel not appending sheets to a file

Hi, 
I have two tfileoutputexcel components under the same subjob connected one to a removeblanks component and the other one to a removedup component. I'm trying to send the info of rejected record from both components to the same file. I have the options to append existing file selected in both tfileoutputexcel however is not appending the sheet for the duplicates. See image below of the subjob
Labels (2)
2 Replies
Jcs19
Creator II
Creator II

huh? me see nothing, I was expecting for a screenshoot
Anonymous
Not applicable
Author

Hi,
Select the check box of  Write excel2007,Include header,Appen existing file,Append existing sheet  in component properties in both tfileoutputexcel component.
See below image:
0683p000009MCgj.png
Thanks,
kumar