Batch Macro Question

[brperkins2]

I am trying to build a simple batch macro. Please see below details of the batch macro.

• Alteryx Date Batch Macro : The input to this macro is a text input tool with 3 dates in a column. Once I call the batch macro, I want this to run a loop for each date and then append / union the output together or seperately to be unioned up later into a master alteryx database file.
• How can I append each run to the master alteryx database file? Currently this is only outputing one alteryx database file with only one date, not three. It is not consolidating the output.

Please see attached clean example. Thank you.

[ChrisTX]

Batch macro results are automatically Unioned together.  You'll need to overwrite your YXDB file in the main workflow, not in the batch macro.

Chris

[CoG]

Unfortunately, .yxdb files cannot be appended to. The file is overwritten with every run. One of the simplest solutions would be to convert the Output Tool to a Macro Output Tool. The nature of a batch macro is such that the outputs are all unioned together. You can thus place your Output Tool outside the macro and it should work fine.

Hope this helps and Happy Solving!

[OTrieger]

@brperkins2 
There is a way to do it. You will not actually going to append it, but what you will do is connecting the database as an input and then what you will do you will always add the new data to the existing data and then you will overwrite it with the full data, the old data with the new just you just added.
So one of your input files will be also the output file.

I did it in the past and it will work with out any issues.

So as explained above you will not really append it, but what you will do pull in the old data and add the new data and overwrite the file with all the data.