Macro to change file inputs

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!

Input

Batch Macro

Accepted answers

Thanks! I ended up inputting a directory (including sub-directories) into a macro, and that worked.

All comments

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 *.*

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!

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335