Batch filter to spit out multiple workstream

I have a transaction dataset by country (maybe include 20 countries) as Summarize can easily aggregate the country info. Instead of manually throwing in a bunch of filters to spit out one workstream per country, is there any way to combine the Summarize result with Macro to produce subset data per country?

Dynamic Processing

Accepted answers

jdunkerley79

If all twenty have different workflows am not sure that a batch would help you. If they are all the same then yes a batch macro would work.

One other set of tools to look at is the CReW macros. The List runner macro would let you run different workflows for each. You could use the output tool to drop a yxmd input for each workflow you need to run. Afterwards a dynamic input would let you read all the results and aggregrate.

As I dont have much details fairly generic solution for you am afraid,

All comments

jdunkerley79

You can use a field in the data to cause the output tool to write to different files:

Not sure if this would be enough for what you need.

Wangwn

Thank you for your quick reply! Although I meant the downstream workstream in Alteryx for further data manuipulation, not for output file. For example I want to to desgin different workstreams based on the existing country value from the source data, in case I have 20 countries, I may need to plug in 20 filters then move along. Is that possible to perform this task as a batch?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335