Group Telephone Numbers into Ranges

[nr642u]

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

[Aaron_Harter · Accepted solution]

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!

 

[atcodedog05]

Hi @nr642u 

Here is a workflow for the task.

Input:

Output:

It creates numbers between the ranges with same ID

Workflow:

Hope this helps 🙂

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

[nr642u · Accepted solution]

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