We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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
8 - Asteroid
Spoiler
402.png
braveraj
10 - Fireball
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
8 - Asteroid
Spoiler
 
Screenshot 2023-11-27 135618.png

 

AndrewDMerrill
13 - Pulsar

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
10 - Fireball

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