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
Solved! Go to 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!
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 😀👍
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