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.
Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
This is one of those challenges (in my humble opinion) where it's easy to get tripped up on what to do just from misunderstanding the data process (not necessarily Alteryx). So I wrote out steps!
My steps:
Spoiler
1. Split VINs into individual characters.
2. Assign character positions using the Tile tool.
3. Extract the 9th character as the original check digit.
4. Remove position 9 from further calculations.
5. Join to a lookup to convert characters to numeric values.
6. Join to a lookup to get the weight for each position.
7. Multiply numeric value by weight.
8. Sum the weighted values per VIN.
9. Apply modulus 11 to the sum.
10. Convert 10 to 'X', else keep the number.
11. Compare to original check digit.
12. Count how many VINs are valid.
Screenshot:
