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.

Create_Date_Macro.yxmc

Date_Macro_Workflow.yxmd

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.