Help Needed In Automation

rmitra14

Hi,

Please find the attached workflow and the sample input data.

I am calculating median income in this workflow.

There are 10 Deciles. And I want to get output of 10 deciles at a time without running it 10 times.

Is there any way to do it? Is there any scope of using Macro and get the desired output for all groups at a time?

Thanks in advance for your help.

test.yxzp

Help

Accepted answers

danilang

Hi @rmitra14

While @WillBowman is correct in saying that you can use a macro to run the various iterations, you don't require one. You can calculate all the Med_Incomes in one workflow by carefully grouping by decile throughout your workflow in the summary, sample and Multirow tools and ensuring that the various Joins and select tools include the decile field

The attached workflow is a simple modification of yours and does exactly what you want. No macros required

Dan

test all.yxmd

All comments

WillBowman

You can use a batch macro and group by the Deciles field or have the batch macro inform a filter change. If I have time later today I will try to demo it.