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? WhereAgePeriodValue 1CategoryIn1701 20074432701Out1701 20074489602In1601 20084432702In1601 20084535202In1501 20094432701In1501 20094490802In1501 20094513801Out1501 20094531301In1401 20104432701In1401 20104519502In1301 20114432702Out1301 20114534501In1201 20124432701In1201 20124510302In1001 20144432701In1001 20144432701In1001 20144432702In1001 20144476201Out1001 20144531601Out1001 20144531601

Batch Macro

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

Workflow

Help

Accepted answers

rzdodson

@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.

All comments

rzdodson

@berty

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

Solution.yxzp

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

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335