Dynamic output filename
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @mbarone , let me try and I will post here 😊
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the tip @atcodedog05 , I will test and post here :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, it works with a small modification
"OutputToolExample_RegionGrouped_"+[Region]+".xlsx|Sheet1"
is modified to
"OutputToolExample_RegionGrouped_"+[Region]+".xlsx|||Sheet1"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks ... works with small modifications to additional hints supplied by @atcodedog05
![](/skins/images/9AF25434D4F136B28264A96CA92E8A93/responsive_peak/images/icon_anonymous_message.png)