Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #402: Parsing Equipment Tags

nSpire
9 - Comet
Spoiler
402.png
braveraj
11 - Bolide
Spoiler
Tag Parse Workflow.pngTag Parse Results.png
TonyAndriani
9 - Comet

My solution.

Spoiler

WC 402.png

 

nhardin
7 - Meteor
Spoiler
Screenshot_solution_402.png
logdog0411
9 - Comet
Spoiler
 
Screenshot 2023-11-27 135618.png

 

CoG
14 - Magnetar

This was a good challenge! Interesting workflow.

 

Spoiler
Screenshot.png

 

 

SandroGerber
8 - Asteroid
Spoiler
Screenshot 2023-11-27 213806.png

harsesh
6 - Meteoroid

My Solution 

olga_strubbe
11 - Bolide

Thank you, @AYXAcademy for a fun challenge!

And big thanks to  @alexnajm and @Federica_FF  for sharing a resource (link below) for how to convert letters to a number sequence!

Solved: Generate Rows: increment letters like numbers - Alteryx Community

 

2023-11-27_16-16-00.png

ggruccio
ACE Emeritus
ACE Emeritus

I probably took the long road!  😂

 

Spoiler
I can't resist using iterative macros!  I wasn't sure the generate rows tool could handle letters so I assigned each letter a number then passed each row into the macro and generated rows between the starting and ending 'letter'.  Then converted the output back to letters.  Throw in some Regex and we have a new tag!

402a.png
And the macro:

402b.png