Input Filename Changes with Date
- 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
I am trying to import a file whose name is changed daily with the date as part of the filename. How can I tell Alteryx to look for a filename with today's date in it?
- Labels:
- Connectors
- Fuzzy Match
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @BrentO
The method would be to use dynamic input tool.
This post by @HomesickSurfer is nearly to the point.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @BrentO
Here is how you can do it.
Workflow:
1. Using directory tool to point to the folder and read filenames of all the files.
2. Using select tool to keep only filename and filepath.
3. Using filter to keep the filename which has today's date.
4. Using formula tool to create full path with sheet name specified.
5. Using dynamic input tool the specific file.
Interactive lesson on dynamic tool : https://community.alteryx.com/t5/Interactive-Lessons/Connecting-to-Multiple-Sheets-at-Once/ta-p/8287...
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@atcodedog05 , thx for the mention.
@BrentO , use the provided example and filter files with Contains([FileName],DateTimeToday()), assuming that your files contain date with yyyy-mm-dd format. If not, please advise and provide sample filenames.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BrentO - Let me offer up one more solution for dynamically bringing in the latest file created.
This method will work regardless of whether the date is in the filename or not.
Cheers!
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What will be the configuration for Dynamic Input tool ? Can you please share sample workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Maskell_Rascal I have encountered times when the creation date isn't always reliable due to file restore or files being created over long weekends at the same time, both bearing same date, hence going with the filename date approach (if a date exists in the filename.