Hi,
I have a template file "Blob test.xlsx" (attached) that is formatted and empty that I want to populate with data from my workflow (WF).
I use the template in the Blob input and then prepend the period to the file name (Mar'25), which outputs the correctly named output "Mar'25 Blob test.xlsx".
I would then like to use this in my output tool. The period in the file names needs to be dynamic, and will be changed each period, but I don't want to have to change this in the output tool each time. I have added a formula tool before the output that will create a new File Name that matches that of the Blob Output file.
The Blob part of the WF is contained in a Control Container so that it completes that part of the process first, but when I run the WF, I get the following error:
Error: Output Data (5): Error while appending to existing sheet in Excel. File does not exist: C:\Program Files\Alteryx\bin\Mar'25 Blob test.xlsx
My Output tool is configures as follows:
 
Is what I'm trying to do achievable, and if so, is this the best way to do it?
