Dynamic Group By

[Balajiprasad]

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!

[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?

[BenMoss]

The only way I see this being dynamic is if you want the logic to be like 'group by every field apart from the salary field which you sum', this is possible, and I have provided an example for you (Y)

[ponraj · Accepted solution]

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

[Balajiprasad]

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