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

[alexnajm]

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

[alexnajm]

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]

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

Spoiler

[Qiu]

@alexnajm 
I managed to upload the Excel as below.

[Qiu]

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

Spoiler

[alexnajm]

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

[RWvanLeeuwen]

Here's my take

Spoiler

[alexnajm]

Eventually uploaded a csv version and got it working

Spoiler

[mikecusic]

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