Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

General Discussions

Discuss any topics that are not product-specific here.

How to update the summarise tool group option using interface tool.

Rihan_Mohamed
8 - Asteroid

I have the below fields in my data Seg1 to Seg5 and Also i have Key Level field which shows the combination level. So, my idea is to create an Alteryx App based on the Key level the summarize level should automatically change. I have attached the sample workflow for the refence, could someone help me with this task,

For example, if the key level is Seg1+Seg2+Seg3 then the summary tool should automatically change it to that level.

 

1.png

 

 

 

 

 

 

 

 

 

 

2.jpg

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

hi @Rihan_Mohamed 

As I could not come up with how to dynamically specify the field for Group By in Summarize tool, I suggest another way.

Instead of using the column "Key Level", I made my WF so user can specify the fields to be grouped by.

My WF seems a bit long and not sophisticated but this is my best at this moment.

image.png

Labels
Top Solution Authors