Import Excel Sheet where name slightly changes
- 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
Hi All,
I'm trying to configure my input tool to use a wildcard in the Sheet name. The file name will be static but the Sheet Name with be some variation of "Export-*" (Export-1,Export-2,Export-3,etc.). I can't seem to find how to do this in the normal Input Data tool.
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The following thread should help, typically the dynamic input or batch macro approaches work best here.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-dynamic-sheet-name/td-p/746247
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I dont think my firm has the newest version of alteryx available because I cant download your solution. Would you mind showing me how you have the dynamic input configured?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@LoganDougherty Try this.
You just have to import the packages.
Basically you'll want to use the input tool to bring in the sheet names of your workbook, using those sheet names and a formula construct a full path, and then pass that path into the dynamic input tool.
