Filed update on Summarize tool

[kauser]

Hello, 

is there any way that Summarize tool can be update based on filed available because items can be more or less Quarter over Quarter. For example in Q1 i might have 4 items to sum and then in Q2 i might have more or less items to Sum. So when i build my workflow in Q1 i have 4 items to sum but when in Q2 there are only 2 items to sum so i get error message that third and fourth items are missing. is there any way i can summarize only what are available based on quarter data rather than manually adding missing items into source file. 

Data from Q1
Data from Trasnpose Tool
Field	Type
Red	V_String
0000	Double
0123	Double
0908	Double
0055	Double
Total	Double
Data in Formula tool
Field	Action	Output Field Name
GLCF_Prod_Code	Group By	Red
0000	Double	0000
0123	Double	0123
0908	Double	0908
0055	Double	0055

Data from Q2
Data from Trasnpose Tool
Field	Type
Red	V_String
0000	Double
0123	Double
Total	Double
Data in Formula tool
Field	Action	Output Field Name
GLCF_Prod_Code	Group By	Red
0000	Sum	0000
0123	Sum	0123

in this example above i get error message in Q2  because items 0908 & 0055 have no data in Q2 

[abacon]

Could you export your workflow and post it? I am thinking you could use a batch macro and the option to update raw XML with Formula to dynamically change the fields that are summarized.

[binuacs]

@kauser dynamic summarise tool is an option for your use-case

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Summarize/td-p/1186509