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