Cloud Quest 16: Vehicle Identification Number (VIN) Check Digit Test
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Download the provided JSON file containing your starting workflow.
- Upload the provided Cloud Quest 16 Start.json file into your Analytics Cloud library.
- 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.
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I removed the VIN with the NA first because the article said these never appear in valid VINs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The flow I did in Weekly challenge desktop version #47 is much simpler...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I took the easy route and just did the same thing as #47.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Done - thought it sounded familiar...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
here's my take...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution