Generate rows using an Alpha-Numeric Index

LauraMendes

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

RolandSchubert

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

LetterNumberCode.yxmd