Macro to change file inputs
- 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
Hello, I have a folder of files with unique names that I would like to run through a flow. I can only run a single file at a time through the flow. I need help building a flow/macro that will dynamically update the input files from the master folder ("Channels") into a single output file.
I am relatively new to Alteryx and tried writing a macro that updates the filter the folder "Channels\*.json" before the main flow according to the list of file names (sample below), but the batch macro isn't iterating through the driver list.
Sample file names within "Channels" folder:
after_work_drinks
basketball
I would greatly appreciate any advice on how to work around this! Thank you!
Solved! Go to Solution.
- Labels:
- Batch Macro
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If the file structure is the same, you can do this with a single input tool. Instead of the file name (in the complete path), just write *.*
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi rohanonline,
Are you saying that:
1. I do not need a macro
2. The input file path to the flow would be ....\Channels\*.* instead of ...\Channels\basketball.json ?
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, that's correct.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! I ended up inputting a directory (including sub-directories) into a macro, and that worked.
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)