Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Group Telephone Numbers into Ranges

nr642u
5 - Atom

Hello, 

 

New to Alteryx and I'm trying to prep data for a project. I need to take a list of 78k phone numbers associated with 200 different locations. The numbers are not continuous for each site so I need to group them in ranges.

 

Here's an example: The phone numbers are continuous from ….2000-2016 but they are associated with two different IDs.

 

I need it to look like

 

2014272000-2014272004  8163243

2014272005-2014272005  8132799

2014272006-2014272008  8163243

 

and so on.

 

2014272000 8163243
2014272001 8163243
2014272002 8163243
2014272003 8163243
2014272004 8163243
2014272005 8162799
2014272006 8163243
2014272007 8163243
2014272008 8163243
2014272009 8162799
2014272010 8162799
2014272011 8162799
2014272012 8163243
2014272013 8162799
2014272014 8162799
2014272015 8162799
2014272016 8162799

 

 

 

Any help would be greatly appreciated.

 

Thank you,

Nelson

 

3 REPLIES 3
Aaron_Harter
11 - Bolide

Hi @nr642u,

 

I'm not sure which is the starting data, and which is the desired output... so I built it both ways for you!

1.1.PNG 

atcodedog05
22 - Nova
22 - Nova

Hi @nr642u 

 

Here is a workflow for the task.

 

Input:

atcodedog05_0-1602526938965.png

Output:

atcodedog05_1-1602526985070.png

 

It creates numbers between the ranges with same ID

 

Workflow:

atcodedog05_2-1602527011731.png

 

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

nr642u
5 - Atom

Aaron,

 

Yes! - Thank you! - I apologize for the confusion, I need it to be group into ranges. and the workflow did the trick - appreciate the help!

 

Nelson

 

Labels