Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic Summarize Tool

carguerriero
5 - Atom

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!

2 REPLIES 2
RogerS
Alteryx
Alteryx

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.

carguerriero
5 - Atom

Could you upload an example that I can refer to?

Labels