In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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
‎05-26-2023 07:24 AM

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

Data set.yxmd
Labels:
Reply
0 Likes
3 REPLIES 3
DavidSkaife
14 - Magnetar
‎05-26-2023 07:32 AM

Hi @Promise 

 

The Summerize tool will do the job for you:

 

DavidSkaife_0-1685111504296.png

 

Summerize.yxmd
Reply
0 Likes
FrederikE
13 - Pulsar
‎05-26-2023 07:33 AM

Hey @Promise,

 

You can configure such a Summarize Tool: 

FrederikE_0-1685111616184.png

 

Reply
0 Likes
geraldo
13 - Pulsar
‎05-26-2023 07:36 AM

@FrederikE 

an example

Data setBACK.yxmd
Reply
0 Likes
view community events
Labels
Top Solution Authors
View All