Output tool not actually outputting data

Question

Hi there

I'm encountering an issue in which the Output tool I have at the end of my workflow isn't actually outputting any data once I go into the file and check.

I am asking the Output tool to overwrite a certain sheet in a .xls file based on some data manipulation done previously in the same workflow.

However, even though I see the updated data correctly within the Results window inside Alteryx (when clicking on the tool immediately before the Output tool), the Output tool doesn't seem to be overwriting the sheet I told it to.

D_Y · Answer

Hi @atcodedog05

I found out that the issue isn't with output tool, it's with the underlying xls file that doesn't appear to be overwriting the existing data. Essentially, the new data is being placed underneath the old data instead of the old data being overwritten. I'll start a new thread to ask if anyone's encountered this before.

atcodedog05 · Answer

Hi @D_Y

Can you provide a sample workflow where you are facing the issue.

D_Y · Answer

@atcodedog05 is the only thing you did changing the Output option to Delete Data and Append? Still encountering the issue of the Output tool not actually outputting the updated data.