Formula tool to extract input files that end with date for example "abcd__2023-01-07.html"
- 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 have input data using the input tool. This input data has large number of files, but I want to extract the files that end with suffix today's date. For example "abcd_2023-01-07.html".
Importantly the abcd is an example, it can be anything but needs the suffix as today's date in this format "_YYYY-MM-DD.html"
Solved! Go to Solution.
- Labels:
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @APIUserOpsGiri, are your input files the same in terms of schema (field names, field order, data types etc)? You'll likely need to use a Directory tool and point towards the folder that your files are saved within. After that, you can filter the files (example shown below) and then pull them in through a Dynamic Input tool that'll load them all in:
Dummy FileName field (this is a field that comes out of the Directory output):
Filter condition and output:
There's also more info on inputting multiple files here which will help resolve your issue: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...