Automization of workflow for each Category

[Avani_7476]

Hi , 

I am trying to figure out how to automize the workflow for 500 -600 categories. In the attached workflow i have put a filter of category, I want the same thing to be done one after the other for 500 categories. Output of each category is 21 *4 table ,which needs to be appended one below the other for each category.

Let me know in case of any inputs required.

Regards,

Avani

[MarqueeCrew · Accepted solution]

@Avani_7476,

When you post a yxmd file, the input data doesn't get posted.  You can either sample the data and create a text input tool or you can export a package (yxzp) and it will zip the data.

That being said, I think that you are looking to create a BATCH macro.  You would summarize the field, [Cinema_strID] and use that as a control to the macro.  Within the macro you would run your R tool and it would operate on each unique Cinema value.

You might want to start by reading https://inspiringingenuity.net/2014/02/12/alteryx-simple-batch-macros/

Cheers,

Mark