Hello,
I want to generate rows using an alpha-numeric index (the alpha is A-Z and the numeric is 1-100). So the table below goes from:
Name | Code Range | Lower | Upper |
Accidents | V98-W05 | V98 | W05 |
To become this:
Code | Name |
V98 | Accidents |
V99 | Accidents |
V100 | Accidents |
W01 | Accidents |
W02 | Accidents |
W03 | Accidents |
W04 | Accidents |
W05 | Accidents |
Please help!
Laura
Solved! Go to Solution.
Hi @LauraMendes ,
CharToInt functions and Generate Rows tool can be used to solve the problem:
I've attached a sample workflow. Let me know if it works for you.
Best,
Roland
Thank you very much RolandSchubert!