Looping on a directory of excel files to read them all
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
MoustafaHebisha
5 - Atom
‎05-04-2023
05:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I created a workflow that works fine with excel files i just need to loop on a directory to apply what i have done on one excel file to the other 32 files so all i need is just an iterative container or something
i don't know how it can be done in Alteryx designer
Labels:
- Labels:
- Input
- Iterative Macro
4 REPLIES 4
geraldo
13 - Pulsar
‎05-04-2023
05:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-04-2023
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes they all start with AMDD but if you are seeking using wildcards (*) it won't work because they have different schemas
binuacs
21 - Polaris
‎05-04-2023
05:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MoustafaHebisha Have you tried the batch macro
geraldo
13 - Pulsar
‎05-04-2023
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In this example I'm putting subdirectories to read the root folder in the directory tool and I'm putting excel files starting with "es" to read.
Perhaps the example will help you to make the necessary adjustments .
attached workflow