Rename output Dynamically inc. Blob tools

[Andrew_T-H]

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?

[alexnajm]

You need the Full Path, not just the File Name, based on your Output Data settings!