Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello,
I have a list of numbers and number/character mixes like the below:
1000
1001
1002
1004
1005
1006
1M27
1M28
1M29
1M31
1M32
1J78
1J79
1J80
I would like the output to look like the following:
| Name | Min | Max | Count |
| Range 1 | 1000 | 1002 | 3 |
| Range 2 | 1004 | 1006 | 3 |
| Range 3 | 1M27 | 1M29 | 3 |
| Range 4 | 1M31 | 1M32 | 2 |
| Range 5 | 1J78 | 1J80 | 3 |
Is there any way it is possible to create a flow to do this automatically?
I was able to create the flow I'll attach below to perform my ask for numeric values, but can't figure out how to get it to work on the number/character mix values like "1J78"
I would really appreciate and input on this issue, thank you in advance!
Rob
