Cloud Quest #26: Concattributes

[mikecusic]

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:

• Getting Started with Designer Cloud
• Building Connections in Designer Cloud
• Building Your Workflow in Designer Cloud

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!

 

Download Start File | Download Solution File

[ggruccio]

Fun and required some thought!

Spoiler

Two separate datastreams - one that used the summarize tool to concatenate with \n as the delimiter and the other as comma-space.

[JeffF]

I think the instructions could be a little clearer about the stats column. The expected output does not include the stat if the value is empty. I figured that out after my result didn't match the provided output.

I spot checked a couple of other posted solutions and they missed that detail. As an example, for ID 3 - Absorbing Man they show:

Height - 193
Weight - 122
Intelligence -
Strength -
Speed -
Durability -
Power -
Combat -

Instead of this from the provided output file:
Height - 193
Weight - 122

[Carolyn]

Solved!

Spoiler

[patrick_digan]

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

[JoachimCaronTIL]

Here is my solution

Spoiler