Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

Prabhakarkunal04
7 - Meteor

Done

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1669748916355.png

 

kom29
7 - Meteor

sol

Pulkitkhattar
8 - Asteroid

solution

PeterHajnal
8 - Asteroid

my solution

Archanap123
6 - Meteoroid

Weekly challenge uploaded 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

This was beastly! I'm sure my workflow isn't as elegant as others. I actually leveraged the Generate Rows tool here to extract each element from the VINs. Stoked with how it turned out and the researching element of the challenge was fun. I'll certainly be tackling this problem again but I will be adapting it by learning from others' solutions. 

 

I attached the picture for Generate Rows tool which I paired with the Formula tool. In essence, I could have split the string via Regex but I was trying to get funky with it 😂.

 

Spoiler
BS_THE_ANALYST_0-1672427611467.pngBS_THE_ANALYST_1-1672427808968.png

 

 

All the best,
BS

LinkedIN

Bulien
gautiergodard
13 - Pulsar
Spoiler
solution
Carolyn
12 - Quasar
12 - Quasar

Solution - hardest part was figuring out what the Wiki article was saying. I had to cheat and look at the solution. It was easy once I stopped being stuck :) 

lhalliwell
8 - Asteroid
Spoiler
Screenshot 2023-01-04 170104.jpg