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...
Hi Maveryx,
Welcome to your very first Cloud Quest! This initiative is a thrilling journey into the world of the Alteryx Analytics Cloud, and we are kicking things off with a focus on Alteryx Designer Cloud. These new quests are not only tests of your skills but also opportunities to delve deeper into the practical uses of Designer Cloud in handling real-world data issues.
In the world of data processing, text files often include quotes, which are commonly used to manage strings. This can pose a unique challenge for extract, transform, and load (ETL) programs due to the presence of multiple character types.
In this quest, you have a CSV file containing two rows of concatenated data that include double quotes, single quotes, and commas, which enclose different data types. Use Designer Cloud to separate the data into three different columns: Poem, Poem ID, and Poem Read Date. Refer to the image below to see how your solution should look.
Hint: A combination of Formula, Text to Columns, and Select tools should be suffice to solve your problem!
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:
Getting Started with Designer Cloud
Building Connection in Designer Cloud
Building Your Workflow in Designer Cloud
Once you have completed this quest, capture a screenshot of your finalized workflow in Designer Cloud and attach the image of your solution to a comment on this post.
Here’s to a successful quest!
SOLUTION
... View more
This week's Challenge comes to you courtesy of Alteryx ACE @NicoleJohnson! If you're at Inspire EU today (Wednesday 10/10), come join us for the session "Alteryxing the Weekly Challenge" at 10:30 in Cutty Sark!
The Case: Mr. Boddy was recently on a trip to London when he unfortunately met with his untimely demise... But whodunnit?? In the spirit of the game Clue (a murder mystery game originally called Cluedo, created by Anthony E Pratt from Birmingham, England in 1949), follow the clues to figure out who committed this dastardly deed, where the crime was committed, and which weapon was used!
*** Once you have all 3 answers, enter your answers into the Clue! Macro to see if your sleuthing is correct! You can also spot check any of your 3 answers in the macro as you go along... ***
Don't forget to post your solution and tag your team members that helped reach the solution!
... View more
Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #33 is HERE. For this chalenge let’s look at creating a macro from scratch. I recommend you first solve the problem with tools on the canvas, then cake a macro from the tools.
Use Case: Our customer has a need to convert date/time strings into a date-time format.
Examples of the different input formats include: 4/8/2015 4:00, 5/10/2015 13:00. The conversion is automatic when the hours are 2 digits (10-24), but it ignores hours 1-9 (creates NULL values on conversion).
Objective: Create a macro to effectively convert and preserve the data in a date-time format.
... View more
Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #16 is HERE. This week’s assignment is listed as an advanced exercise due to the requirement of using a batch macro for the solution.
The use case: A bank is looking to calculate customer retention rate month over month. The denominator in the calculation are all of the accounts open 24 months prior to the start of the month. For example, for June 2013, the denominator would be the total number of accounts open between June 1, 2011 through May 31, 2013. The numerator will be total number of accounts closed in June 2013 or between June 1, 2013 through June 30, 2013.
The objective is to create a batch macro that calculates the retention rate for May, June, July and August.
... View more
A solution to last week's challenge can be found here!
This week's challenge was submitted by @kelly_gilbert - thank you for your contribution!
Challengers, get ready to have some fun with this one! And, with various levels of difficulty built into this challenge, there's something for everyone!
Your challenge this week is to build a Bingo Card! This challenge uses events/observations from a baseball game, but you can customize this input for anything from traditional numbers to things you might see at Thanksgiving Dinner. Enjoy!
Source: GIPHY
... View more