Dynamic output filename

[chrissgtan]

Hello Alteryx Community,
Could inspect the attached yxmd, please?
I am wondering why the tool could not do the same for Excel files. I mean, it could do the following as expected for yxdb
     OutputToolExample_RegionGrouped_Midwest.yxdb

But it could not do the same for xlsx
     OutputToolExample_RegionGrouped_.xlsx
For output to Excel, it created 4 worksheets with the suffix, example "Sheet1Midwest"

What have I configured incorrectly for Excel output? 

Thanks,
Chris

[mbarone]

Unfortunately it puts the dynamic name at the very end of the connection string, so it's doing it after the sheet name.  For Excel, you need to create the output path using a formula tool, and then "change entire file path" in the output tool's option at the bottom.  Let me know if you need further clarification.

[atcodedog05]

Hi @chrissgtan 

Excel has the concept of table which is sheets and works differently compared to over flat files. To add region in the filename as suggested you need to replace full path like below.

Input:

Output:

Hope this helps : )

[chrissgtan]

Thanks @mbarone , let me try and I will post here 😊

[chrissgtan]

Thanks for the tip @atcodedog05 , I will test and post here :-)

[chrissgtan · Accepted solution]

Thanks, it works with a small modification
"OutputToolExample_RegionGrouped_"+[Region]+".xlsx|Sheet1" 
   is modified to

"OutputToolExample_RegionGrouped_"+[Region]+".xlsx|||Sheet1"

[chrissgtan]

Thanks ... works with small modifications to additional hints supplied by @atcodedog05