Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest 16: Vehicle Identification Number (VIN) Check Digit Test

mikecusic
Alteryx Community Team
Alteryx Community Team

Hi Maveryx,

 

We posted the solution JSON file to Cloud Quest 15. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

 

 

Let’s dive into this week's quest!

 

  1. Download the provided JSON file containing your starting workflow.
  2. Upload the provided Cloud Quest 16 Start.json file into your Analytics Cloud library.
  3. All necessary datasets are contained within Text Input tools in the workflow.

 

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.

 

Scenario:

 

NOTE: Designer Cloud Standard Mode is required to complete this quest.

 

You are working as a data analyst in the automotive industry. You need to build a process to validate vehicle identification numbers (VINs) to test for data quality issues across vehicle fleet data. The algorithm that validates VINs is explained in the Check-digit calculation section of the following wiki link.

 

http://en.wikipedia.org/wiki/Vehicle_identification_number

 

Your task is to take the VINs from the VIN List Input and create a new column for the check digit. The check digit is always the 9th character in the VIN. Compare the check digit with the calculated check digit value. If the two values do not match (and there was no error in the calculation), then there is a mistake in the VIN. Out of the six VINs provided, how many vehicles have a valid VIN?

 

The relevant lookup tables have been provided.

 

Hint: Use the function Mod([Sum_Product], 11) to compare against the VIN check digit as explained in the Wiki article.

 

Spoiler
A combination of the Summarize, Transpose, Join, Formula, Filter, and RegEx tools should solve your problem, but not necessarily in this sequence.

 

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:

 

Once you have completed your quest, go back to your Analytics Cloud library.

  • Download your workflow solution file.
  • Include your JSON file and a screenshot of your workflow as attachments to your comment.

 

Here’s to a successful quest!

 

mikecusic_0-1725457453744.png

 

7 REPLIES 7
ggruccio
ACE Emeritus
ACE Emeritus

I removed the VIN with the NA first because the article said these never appear in valid VINs.

 

Spoiler
Screenshot 2024-09-04 134126.png
JeffF
Alteryx
Alteryx
Spoiler
Quest16_JeffF.png
Qiu
21 - Polaris
21 - Polaris

The flow I did in Weekly challenge desktop version #47 is much simpler...

Spoiler
Cloud Quest 16.png
patrick_digan
17 - Castor
17 - Castor

I took the easy route and just did the same thing as #47.

Spoiler
 

image.png

alexnajm
17 - Castor
17 - Castor

Done - thought it sounded familiar...

Spoiler
Quest 16.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
image.png

 

I did in Cloud Native Mode.

Spoiler
Basically, the logic is the same as the Standard Mode one.
image.png

 

 

geoff_zath
Alteryx
Alteryx
Spoiler
quest_16_workflow.png