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