Auto-browser for File Name inside a specified Folder
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rjesus1925
5 - Atom
11-17-2023
07:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I'm trying to see if the process that I apply in my file using Power Query is possible in Alteryx so here's my scenario.
What I use to do in Power Query is create a tab for ReportMonth (format: mm-yyyy) so it will automatically look up the specific file inside a folder with the same month given that it has same date format (mm-yyyy) and will load that file into my main sheet.
Sorry if my explanation is a bit complicated..
Thanks,
Ryan Esmalin
Labels:
- Labels:
- Community
1 REPLY 1
21 - Polaris
11-19-2023
03:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rjesus1925
If my understanding is correct, you only want to bring in the file with specific date, and ignore other files in the same folder?
In the Data Input tool, we can use the wild card "*" to match your date in the file name.
Is this what you need?
