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