Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
Happy Halloween loyal weekly exercise participants, here is an exercise I hope does not scare you too much. Hopefully is a treat and not a trick. The link to last week’s challenge is HERE.
Use case: An Alteryx subscriber needs to build a process to validate VIN numbers to test for data quality issues across the fleet data. The algorithm is provided at the below wiki link.
http://en.wikipedia.org/wiki/Vehicle_identification_number
Objective: Please take the VIN numbers from the Input and create a new column for the check digit. 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, how many vehicles have invalid codes?
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by Patrick Digan (@patrick_digan) an Alteryx ACE and also an active Community member who has contributed to many challenges before. Thank you, Patrick!
This week’s challenge is inspired by a special day that just passed: Pi Day! Not the delicious treat, but the number with an infinite sequence of non-repeating decimals: 3.14, which is celebrated on March 14.
In honor of pi, this week your task is to find all 13 numbers less than or equal to 100,000 that are equal to the n th power of the sum of their digits. For example, 81 is a 2-digit number, so n=2, and (8+1) 2 = 81; therefore, it falls under the category we are looking for.
For the input, use the Generate Rows tool to generate numbers from 0 to 100,000.
Bonus question: If you want to take your skills to the next level, you are invited to find all 17 numbers that are equal to any n th power of the sum of its digits. For example, 4,913 works for this. While it will fail for the first task because (4 + 9 + 1 + 3) 4 = 83,521, the number 4,913 works well for the bonus question since (4 + 9 + 1 + 3) 3 = 4,913.
Need a refresher? Review these lessons in Academy to gear up:
Summarizing Data
Creating Regular Expressions
Good luck!
... View more
A solution to last week's challenge can be found here!
Using the data provided in the start file, create an ordered list of the provided unofficial holidays.
GIPHY
Get ready for Answer the Phone like Buddy the Elf Day on December 18!
... View more
A solution to last week’s challenge can be found here.
Welcome to the Good Ladies weekly challenge!
Five women heist a jewelry store and steal a precious gem in the shape of a ball of yarn.
In the dataset, the 5 women responsible for the heist have been negligent and left clues behind. You are the detective on the case who is looking for these clues in a dataset.
1. Fingerprints on the glass surrounding the gem show fingerprints belonging to someone with the letters "Fled" in their first name or last name.
2. IT Department at the police is able to find that the back door lock password was changed to "ugfsjsh".
3. The vault holding the gem was blown open with "dynamic" dynamite. Found in the ruble is a business card piece. You can make out the first few letters of the word "Bogi"
4. The security guard's witness statement states that he has been vigilant about watching the store. There was only one instance last week when he was distracted by a woman with brunette hair who worked at a wireless store. He remembered later that she'd dropped a handkerchief that had the initials B.K. on it.
5. A slogan was left behind that said, "Those that synergize together can accomplish much and receive the TORPHY."
First, you will have to parse the data.
... View more
A solution to last week's challenge can be found here.
This week's challenge marks the culmination of a trilogy of challenges inspired by the 2023 Inspire Grand Prix. These challenges explore real-world scenarios that many companies frequently face. The previous week's challenge involved a spatial problem, while the week prior focused on data preparation and integration. In this concluding challenge, we will delve into a predictive case.
If you are eager to experience the same exhilaration our racers feel in Las Vegas, take a quick, 2-minute glance at the instructions, start your timer, and record how long it takes you to determine the correct answer! Remember to share your time when you submit your workflow.
Let’s start now: 3, 2, 1, Go!
A driver who works for ACE was recently promoted to shift manager, so the company needs to reduce their weekly food collection schedule by five shifts until they can fill the driver position.
1. Which five shifts are most likely to be unsuccessful?
Build a random forest model to determine the five collection shifts with the highest likelihood of having a cancellation based on historical job data. For the forest model, use only the DistanceMiles, Hour, and DayofWeek columns as your predictors.
For the cancellation data, you will need the calculate the following:
DayofWeek: The exact field name, full name of the day, and (%A) the job occurred based on the Date.
JobStatus:
• A value of Unsuccessful if the job was canceled. • A value of Successful if the job was successful based on ClosedReason values. A Successful value would be any ClosedReason starting with 01 or 02 and an Unsuccessful value would be any other value.
... View more