Batch Macro

[berty]

Hello, 

I'm trying to run a report to using a batch macro due to alot of data processing, my intention is to group a number of rows based on the same reporting period. For each of those reporting periods i want the batch macro to run and  group each reporting period produce a separate output file, for the example below, i would expect 7 files from this 1 input -  I've never attempted something like this,  is anyone able provide some guidedance on how i could achieve this?

Where	Age	Period	Value 1	Category
In	17	01 2007	44327	01
Out	17	01 2007	44896	02
In	16	01 2008	44327	02
In	16	01 2008	45352	02
In	15	01 2009	44327	01
In	15	01 2009	44908	02
In	15	01 2009	45138	01
Out	15	01 2009	45313	01
In	14	01 2010	44327	01
In	14	01 2010	45195	02
In	13	01 2011	44327	02
Out	13	01 2011	45345	01
In	12	01 2012	44327	01
In	12	01 2012	45103	02
In	10	01 2014	44327	01
In	10	01 2014	44327	01
In	10	01 2014	44327	02
In	10	01 2014	44762	01
Out	10	01 2014	45316	01
Out	10	01 2014	45316	01

[rzdodson]

@berty 

See attached. Hope that gets you started down the right path. :)

[berty]

this is an excellence solution, actuall really simple idea but i think i need a batch macro because i need the alteryx flow to run separately for each reporting period, the actual data is written to xml source code - the period field isnt carried through the entire flow. 

[rzdodson · Accepted solution]

@berty no worries. Sounds like you may have some additional processing that you need to perform prior to producing the reports.

If that's the case, you can open the batch macro that is included in the workflow and start inserting any number of tools between Formula (9) and Output (10). The syntax in Formula (9) will enable you to output the requisite number of files you need, and will save them to the directory where the workflow is saved. :)