Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #8: Settle the Score

AYXAcademy
Alteryx
Alteryx

Hi Maveryx,

 

We posted the solution JSON file to Cloud Quest #7. 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. Upload the provided Cloud Quest 8 - Start File.json file into your Analytics Cloud library.
  2. The input and output datasets are included in the start file.

 

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:

 

A group of friends are playing their favorite game. Not understanding the importance of inputting data in an easy-to-work-with format, they devised an incredibly inefficient way to keep score of their game!

 

In the game, there are five rounds of play and five players (a, b, c, d, and e—the first letter of their names). Each time the player’s initial appears in lowercase, the player is awarded 1 point. Each time their initial appears in uppercase, 1 point is subtracted from their overall score. Now it is your job to figure out each player’s score for each round and their respective totals after all five rounds of play. Who won? 

 

Hints: 

  1. Tokenize the input data into rows.
  2. There are many ways to calculate scores for each letter, but an If/Then statement can accomplish this in one expression.
  3. When pivoting, you can perform multiple calculations at once including Sum and Total Column.
Spoiler

A combination of the Cross Tab, RegEx, Formula, and Dynamic Replace 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:

 

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!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

28 REPLIES 28
JoachimCaronTIL
8 - Asteroid

Here is my solution

 

Quest 8 JC.png

ScottMcV
Alteryx
Alteryx

 

I saw the missing case sensitivity someone referenced elsewhere that would have made it easier and ran into it myself.

 

Spoiler
Cloud Quest 8.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
I hope that the RegEX_Match function has the case intensive option similar to the Designer Desktop.

スクリーンショット 2024-05-27 214005.png
Shelbey
Alteryx
Alteryx
Spoiler
Screenshot 2024-05-30 131223.png
Towers
11 - Bolide

really like regex 

Spoiler
Screenshot 2024-05-31 161502.png

RobertW
Alteryx
Alteryx
Spoiler
 

Screenshot 2024-05-31 at 2.08.41 PM.png

mceleavey
17 - Castor
17 - Castor

Nice and easy. Come on, Alteryx gods, challenge me. Really go to town on me.

 

Spoiler
I tokenised the Score string to rows using any character, then regex matched the uppercase characters. I then assigned points to the matched/un-matched records then set all to lower case. Then I simply cross-tabbed back creating a sum by each character and created the total field.
Workflow.pngResults.png


Bulien

OllieClarke
15 - Aurora
15 - Aurora

I thought that would be more straightfoward

Spoiler
Who knew = was case insensitive :(

Quest_08.png
OllieClarke
15 - Aurora
15 - Aurora

@mceleavey I know my attempt is way more convoluted than yours, but you can drop a tool by creating the total column in the cross-tab as well :)

mceleavey
17 - Castor
17 - Castor

You are correct, sir! 



Bulien