Cloud Quest #25: What a Combo!

[mikecusic]

Hi Community,

We posted the solution JSON file to Cloud Quest #24. 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 the provided JSON file containing your starting data and workflow files.
2. Upload the provided Cloud Quest 25 Start.json file into your Analytics Cloud library.
3. All necessary datasets are contained within Text Input tools in the workflow.

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:

This week's quest was adapted from a submission by @Kenda. Thanks for your submission!

Mathematicians and statisticians frequently work with permutations and combinations. This week’s quest focuses on combinations. You are tasked with using 26 unique variables, represented by the letters of the English alphabet, to generate a list of all possible combinations of 3 variables (denoted as 26C3). Keep in mind that in combinations, the order of variables does not matter, and no variable can appear more than once in any given combination.

Hint: Start with the tool that creates Cartesian joins.

Spoiler

A combination of the Filter, Formula, Append Columns, and Select 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]

Done!

Spoiler

[ggruccio]

Fun challenge - I had to refresh on combinations vs. permutations!

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

[Qiu]

Nice one!

Try to go with a different way. 😁

Spoiler

[RWvanLeeuwen]

here's my take

Spoiler

[patrick_digan]

Spoiler

[JeffF]

Spoiler

Not the most efficient.

[Carolyn]

Solved! Really fun :) 

Spoiler

I added the RecordIDs initially so that way after the Appending x2, I could just filter for where RowID < SourceRowID, etc

Not counting the Select to remove unneeded rows, I ended up with a 5 tool solution - I'm very happy about that!