Summarize tool

meghussong

I am currently taking a class in college that involves using Alteryx. We are learning how to use the summarize tool. I am trying to use the summarize tool to find the 5 highest performing regions for a particular product. Although I can find this through other tools easily, I am given an output that should match my output. I believe based on the formatting of the given output I would need use the summarize tool but cannot figure out which action to use. I am including pictures of my given data and given ending output. Any tips on what action to use or if I am using the wrong tool?

Screen Shot 2024-02-28 at 7.23.31 PM.png

Screen Shot 2024-02-28 at 7.23.50 PM.png

Gawa

hi @meghussong You need to do some steps before using Summarize too to get the desired output. As it seems this question comes from your educational content, I just introduce the tips instead of sharing the direct solutions.

First, use Sort tool to sort data in the order of performance(it should be descending order)

Second, use Sample tool to get the first 5 records.

Third, use Summarize tool to combine strings.

*If you need more straight answer on configuration of Summarize tool, collapse the below spoiler

Spoiler

In the configuration of Summarize tool, specify Concatenate so as to combine strings