topic tFileOutputExcel in Data Quality

tFileOutputExcel

Valentinas — Fri, 15 Nov 2024 23:28:15 GMT

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

Re: tFileOutputExcel

Anonymous — Wed, 01 Dec 2021 06:45:17 GMT

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