We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generate rows using an Alpha-Numeric Index

LauraMendes
7 - Meteor

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:

 

NameCode RangeLowerUpper
AccidentsV98-W05V98W05

 

To become this:

 

CodeName
V98Accidents
V99Accidents
V100Accidents
W01Accidents
W02Accidents
W03Accidents
W04Accidents
W05Accidents

 

Please help!

Laura

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @LauraMendes ,

 

CharToInt functions and Generate Rows tool can be used to solve the problem:

 

23-07-_2020_19-19-43.png

 

I've attached a sample workflow. Let me know if it works for you.

 

Best,

 

Roland

LauraMendes
7 - Meteor

Thank you very much RolandSchubert!

Labels
Top Solution Authors