Filed update on Summarize tool

Question

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 Q1Data from Trasnpose Tool   Field Type Red V_String 0000Double 0123Double 0908Double 0055Double TotalDouble    Data in Formula tool  Field Action Output Field NameGLCF_Prod_CodeGroup ByRed0000Double00000123Double01230908Double09080055Double0055

Data from Q2Data from Trasnpose Tool   Field Type Red V_String 0000Double 0123Double TotalDouble    Data in Formula tool  Field Action Output Field NameGLCF_Prod_CodeGroup ByRed0000Sum00000123Sum0123

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

binu_acs · Answer

@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

abacon · Answer

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.