Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #47: Vehicle Identification Number Test

Maskell_Rascal
13 - Pulsar

Fun challenge!

Spoiler
Maskell_Rascal_0-1620332307667.png

 

Cheers!

Phil

alexnajm
16 - Nebula
16 - Nebula

I never would've guessed there's a method to the VIN madness!

Luke_C
17 - Castor
Spoiler
Luke_C_0-1623334916786.png

 

Ajjay
8 - Asteroid

Soln

CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1624564388086.png

 

DSinnett
Alteryx Alumni (Retired)

I'm posting my solution as a lesson to be learned.  The main lesson is that my "strong arm" technique (cycling through each character) is NOT SCALEABLE - not good.  For example, if the length of the Identification Number changes, a lot work is needed to 'fix' this workflow.  The published solution would  need just one change to the RegEx tool.  And, if you're keeping score, I only used one lookup table - another example of my "strong arm" technique; which works, but is not scaleable.

ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-24 184340.png

carmenrapariz
8 - Asteroid
Spoiler
Challenge 47.PNG
Elias_Nordlinder
11 - Bolide

Fun one 🙂

 

Spoiler
Elias_Nordlinder_0-1627629539615.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 47.PNG