Batch macro that output each of the excel file

[terrellchong]

Hi all,

I have a flow that currently is an app.

The flow actually works if I change the input excel file each time, I tried it with 2 of my file.

but the problem is that I would like it to apply all of the excel file inside the folder instead of inserting the excel file 1 by 1 thru the app.

may I know how should I do this? Should I use batch or interactive macro for this?

[binuacs]

@terrellchong use batch macro in your usecase

[rzdodson]

@terrellchong: I would highly recommend that if you were to go the macro route, that you use a batch macro. However, to be clear, you do not need an Alteryx macro to output data to multiple tabs within an output file (xlsx, etc.). All you would need to do is develop some type of dynamic file path to output to the desired location like so:

The [Engine.WorkflowDirectory] variable in Alteryx can be used here as well. It is Alteryx's way of saving the output(s) to the same folder directory where the original workflow is saved.

If you have a copy of any dummy data you have, that would be helpful to calibrate a batch macro solution to your use case. For a batch macro to work properly, you'll need to bring in a Directory tool as your primary input for your workflow. The list of file paths (Directory tool output) would serve as the input for your batch macro. You would develop a macro then that reads those full file paths, then does whatever process you need, then outputs dynamically back to where ever you need the update posted.