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

Alteryx Designer Desktop Discussions

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

Create number range based on a list of numbers and data

Promise
6 - Meteoroid

Hello,

 

I have a data set attached below:

 

The output should look like follow

Countries          MIN     MAX      COUNT

United States

Canada
Mexico
Cuba
Jamaica

 

How can I realize this?

 

Thanks in advance

3 REPLIES 3
DavidSkaife
13 - Pulsar

Hi @Promise 

 

The Summerize tool will do the job for you:

 

DavidSkaife_0-1685111504296.png

 

FrederikE
13 - Pulsar

Hey @Promise,

 

You can configure such a Summarize Tool: 

FrederikE_0-1685111616184.png

 

geraldo
13 - Pulsar

@FrederikE 

an example

Labels