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

[mikecusic]

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:

• Getting Started with Designer Cloud
• Building Connections in Designer Cloud
• Building Your Workflow in Designer Cloud

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!

[ggruccio]

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

Spoiler

[JeffF]

Spoiler

[Qiu]

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

Spoiler