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!
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.
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.
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,