Free Trial

Cloud Quests

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

Cloud Quest #26: Concattributes

mikecusic
Alteryx Community Team
Alteryx Community Team

Hi Community,

 

We posted the solution JSON file to Cloud Quest #25. 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. Download and extract the provided ZIP file containing your starting data and workflow files.
  2. Upload the provided Cloud Quest 26 Start.json file into your Analytics Cloud library.
  3. Reconnect the provided Quest 26 Input.xlsx and Quest 26 Output.xlsx datasets to your starting workflow 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:

 

Superheroes captivate us with their epic tales of extraordinary feats and moral lessons. Whether you’re a fan of the genre or not, they offer a fascinating reflection of human values. At the heart of these stories are the unique superpowers that define each hero.

 

For this week’s challenge, you’ll work with a dataset that lists superheroes along with their various attributes. Their superpowers are recorded as true/false values across multiple columns, while their physical measurements are provided in numeric form.

 

Your task is to make the dataset more user-friendly:

  • Create a Stats column that consolidates all numeric, measurement-related data into a single cell, with each original column listed on a new line.
  • Create a Powers column that includes only the concatenated superpowers the character possesses.

Don’t forget to remove any characters who don’t have superpowers!

 

Hint: If you’re stuck, start with a Transpose tool. Remember that \n is a delimiter or separator that creates a new line within a cell.

 

Spoiler
A combination of the Join, Transpose, Filter, Sort, and Formula 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 Alteryx 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!

 

Academy Wordmark.png

 

 

 

Download Start File | Download Solution File

15 REPLIES 15
alexnajm
18 - Pollux
18 - Pollux

@mikecusic can we have the correct JSON start file? The one in there looks like it is from Quest #25

alexnajm
18 - Pollux
18 - Pollux

Also not sure if anyone else is experiencing this, but I can't upload the Excel file to cloud - submitted a support ticket but seeing if it's just me or not

JeffF
Alteryx
Alteryx

I modified the provided start file to work with this Quest. Just a little extra challenge. :-)

 

Spoiler
CloudQuest26_JeffF.png
Qiu
21 - Polaris
21 - Polaris

@alexnajm 
I managed to upload the Excel as below.

Cloud_Quest_26-A.png

Qiu
21 - Polaris
21 - Polaris

Since the Start file is of #25 so I have uploaded the input and output file.

Spoiler
Cloud_Quest_26-B.png
alexnajm
18 - Pollux
18 - Pollux

@Qiu doesn't work for me - opened up a ticket! Good to know it works for others though

Screenshot 2025-01-22 161827.png

RWvanLeeuwen
11 - Bolide

Here's my take

Spoiler
Cloud Quest 26 RWvL.png
alexnajm
18 - Pollux
18 - Pollux

Eventually uploaded a csv version and got it working

Spoiler
Screenshot 2025-01-23 084101.png
mikecusic
Alteryx Community Team
Alteryx Community Team

Thank you @alexnajm for pointing out this error. Apologies to everyone for the confusion! The link has been updated with the correct start file.