Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How can I select a different file browse for each iteration of a batch macro?

nshields
6 - Meteoroid
Spoiler
 

I have a number of files with identical formats. I want to run each file through an identical flow. Part of this flow will be to join the data frame with another data frame (NOT IN THIS FOLDER). For each file that I am running through the flow, I want the ability to select the other data frame that it will be joined to.

 

I know that I will need a control parameter for the file input tool (to read in one file in the folder at a time). But how can I input another separate file with the ability to select this file's location each time the batch is run? 

 

PUT MORE SIMPLY: I want to read in file A. Then I want to join file A to file B. Then I want to read out the newly joined file. The features I want to be able to do here are to 1) run this whole process using a different file A by looping through all files in a defined folder, and 2) for each run of this process I want to select a different file B. 

 

Thanks! 

3 REPLIES 3
grchavarri
11 - Bolide

I dont know if i understood your idea perfectly, but as far as i know, if you use directory tool and introduce the full path in the macro, you will get your result.

Using in the first step of the macro, a dynamic input tool and selecting the template from the flow.

nshields
6 - Meteoroid

Yes I think I understand how to iterate through different files within a folder.

 

I am more curious if there is a way to read in another file that will be joined to that file, and have the ability to select that other file for each iteration. I've attached a screenshot example. File A will be the one that is dynamically inputted. I'd like the ability to now select File B, but select a different file for each iteration.

grchavarri
11 - Bolide

Hi @nshields  

Please find the image below, if you join the full file paths before the macro like this (all after the red line) you could open each A file with a B file you wanted without a problem. The only issue to count in here is to keep in mind that the output of the batch macro has to have the same structure in every matched files A and B. 

Hope it helps, 

 

grchavarri_1-1636710237642.png

 

Labels
Top Solution Authors