Hi Community,
I have a report that I need to generate using Alteryx. There is an Excel table to which I want to replace the existing information with the data I generated in Alteryx. Every time I go to output it to that sheet Alteryx just creates a duplicate sheet and appends the new data there, leaving the current data in its place.
Does anyone have a solution as to how I can replace the existing data with the new data?
Thank you!
Hi @pvell322
The default setting for outputting to Excel is 'Create New Sheet', change this to 'Overwrite Sheet or Range', or 'Overwrite File' if needed