Dynamic Group By

Hi,

I have a workflow with a summarize tool. I am performing Group By operation for two fields and sum operation for one field.

Now I need to add two more fields in Group By category and perform the same operation. How to achieve this dynamically?

Thanks!

Macros

Accepted answers

ponraj

@Balajiprasad, Attaching a sample workflow. Hope this is helpful.

Dynamic Group By.PNG

Dynamic Group By.yxmd

All comments

ponraj

Possible to share sample data and desired output ?

Balajiprasad

Sure @ponraj . The sample data and desired output looks something like the below. My group by fields are Country and Year and Salary should be the sum.

Country	Year	Salary	Output:
IND	2011	10000	Country	Year	Salary
IND	2011	10000	IND	2011	30000
IND	2011	10000	IND	2012	35000
IND	2012	15000
IND	2012	20000

May be tomorrow i can have two more group by fields Department and Position like the below.

Country	Year	Department	Position	Salary	Output:
IND	2011	IT	Manager	12000	Country	Year	Department	Position	Salary
IND	2011	IT	Manager	13000	IND	2011	IT	Manager	25000
IND	2011	IT	Associate	10000	IND	2011	IT	Associate	10000
IND	2012	ADMIN	TL	15000	IND	2012	ADMIN	TL	15000
IND	2012	ADMIN	MN	20000	IND	2012	ADMIN	MN	20000

I don't want to create one more Summarize tool to do this. Instead I want to do this dynamically. Is it possible?

ponraj

@Balajiprasad, Attaching a sample workflow. Hope this is helpful.

Dynamic Group By.PNG

Dynamic Group By.yxmd

Balajiprasad

Thanks @ponraj this is exactly what i want. But can we do this using Macro and Control Parameters?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703