Batch Macro
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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. :)