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?
Solved! Go to Solution.
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:
Hi Greg,
I gave this a try and was successful. Thanks !