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!
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
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:
Once you have completed your quest, go back to your Analytics Cloud library.
I removed the VIN with the NA first because the article said these never appear in valid VINs.
The flow I did in Weekly challenge desktop version #47 is much simpler...