Append a weekly spreadsheet created in Alteryx to a YTD spreadsheet same format

[bcrosenberg]

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? 

[Greg_Murray]

Hi @bcrosenberg,

Have you tried using the Block Until done tool? I would just add it after your input tool. It should allow Alteryx to complete its read of the spreadsheet before it attempts to write to it.

Here is more info:

Block Until Done

[bcrosenberg · Accepted solution]

Hi Greg, 

I gave this a try and was successful. Thanks !