Macro to change file inputs

[mrackson]

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!

[rohanonline]

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

[mrackson]

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!

[rohanonline]

Yes, that's correct.

[mrackson · Accepted solution]

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