summarize columns dynamically

tanvir_khan

Hi all:

I'd like to prepare output from the input table below. I can do this using summarize tool.

But there may be additional column(s) appear in future. How can I summarize those additional columns as the summarize tool doesn't have dynamic or unknown column features. Is there any alternate way? 

Input

Output

Thanks

Matt_D

Hi  @tanvir_khan you would transpose then crosstab, ensuring in Transpose tool your non aggregation columns were selected as Key Columns, then ensure that Data Columns selected included "Dynamic or Unknown Columns",  then in Cross Tab tool on group by Key Columns,  Name as your Headers, Value as your New Columns, Sum as your aggregation.

If 12 new aggregation columns popped in, they would get summarised.

Example workflow attached which will generate a random mount of columns each time it's ran.

Dynamic Summarise Example.yxmd