In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
Learn more here
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
