Alteryx Output Data Component Not Overwriting my existing data instead it appends the data

Question

Hi All,

I am facing issue with Alteryx Output Data Component, I have selected the option to "Overwrite Sheet (drop)" option. But still it is not Overwriting my existing data from that sheet instead it appends the data with the same sheet. FYI, I am reading the same sheet and doing some data manipulation after that I am writing back to the same sheet. The excel workbook is in .xls format, would be an issue?

grazitti_sapna · Answer

@Parthasarathi  Can you share you workflow and excel files so that I can understand the problem better and provide you with feasible approaches.

Thanks!!

Parthasarathi · Answer

@Sapna Gupta,

The target excel column has a formula to get data from a different excel using VLookup, when it is overwritten by Alteryx while opening the excel getting this warning - "Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)" and no formatting retained. Like formula, font style and cell colors.

grazitti_sapna · Answer

@Parthasarathi , Which format is it not retaining. As in my case when I am overwriting the data to the same file the format of the file is .xlsx only as it was while using it as input. Can you share your workflow so that I can try to provide you specific solution?