Dynamic output filename

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

Dynamic output filename.yxmd

Dynamic Processing

Accepted answers

chrissgtan

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

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

All comments

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 : )

Dynamic output filename.yxmd

chrissgtan

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

chrissgtan

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

SaravanaShan

i am getting extra output as file name and file path

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335