I am updating and saving a weekly spreadsheet in alteryx. As a last step in the workflow i want to append this to the bottom of a Year to Date spreadsheet in the same format. I tried to input the YTD sheet with a union. I get messages that indicate i cannot open the same YTD sheet for output(since i still have it open). Is there a way to append the weekly file to the YTD in the very same workflow?
