Batch Macro to Ouput Files Based on Parameter(s)

Experts -

I essentially need a macro that does the following:

1) Output .yxdb files to locations specified by a strings I pass the macro

2) The number of iterations should correspond to the number of strings that are passed

For example, if I pass the string "\folder1.yxdb" the macro will output the data to this location. If I pass the strings "\folder1\data.yxdb" and "\folder1\ARCHIVE\data.yxdb" the macro will iterate twice, outputting the same data to each location.

Is this possible?

Thank you!

Iterative Macro

Accepted answers

WilliamR

Hi @Bonediggler ,

here is an example of a batch macro taking the path as parameter.

The action tool from the macro just replace the directory of the file using the option at the bottom.

Here is the main workflow. There is one iteration per line in the text input tool.

(If this post helps, then please consider it as the solution to help the other members find it more quickly).

BatchDirectory.yxzp

All comments

BrandonB

I think that you are most likely going to be leveraging the Take File Name from Field option in the bottom of the Output Data tool configuration. This can change the name of the file that is written based on the values that exist in a column.

If you wanted to perform this process for multiple file names, you could put the output tool into its own macro. You would use a macro input (interface tool) connected to a formula tool connected to the output data tool, and then a control parameter with action tool connected to the formula tool. The formula tool would be used to create the file path passed in by the strings that you specify. That way when you have it in your main workflow, the macro will run one time for each file path string that you want to use that is passed in to the control parameter. Also, this would be a batch macro rather than an iterative macro, because it will only process the number of times control parameter values are passed in rather than an iteration process. It is possible to set up an iterative macro in a similar way but it would require more steps and this is the most straightforward method.

WilliamR

Hi @Bonediggler ,

here is an example of a batch macro taking the path as parameter.

The action tool from the macro just replace the directory of the file using the option at the bottom.

Here is the main workflow. There is one iteration per line in the text input tool.

(If this post helps, then please consider it as the solution to help the other members find it more quickly).

BatchDirectory.yxzp

Bonediggler

Thanks William!

Is there any way you can output this in a prior version of Alteryx? I can't open it.

My version is: 2018.2.6.51223.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703