Hi everyone,
I was wondering if there's something like a "Dynamic" Summarize tool in order to autoselect all the variables when there's a change in the workflow.
The problem with my workflow is that it automatically adds a new variable for every new month.
At the end of the workflow I have a Summarize tool with a group by function for all my variables. So, when a new variable is added, the group by function misses it, and I have to manually add it.
Is there a way to make the group by selection automatic?
Thank you!
Try using a transpose tool which has an dynamic/unknown fields option and will create name/value pairs that you can summarize and then cross tab back if needed.
Could you upload an example that I can refer to?