Cloud Quests

AYXAcademy

Hi Community,

We posted the solution JSON file to Cloud Quest #31. 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!

Download the provided JSON file containing your starting data and workflow files.
Upload the provided Cloud Quest 32 Start.json file into your Analytics Cloud library.
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:

A race is being held between four horses. For this week's Cloud Quest, your task is to create an output table of every possible combination of race finishes. No horse should be able to finish in more than one place, but be warned there are two different mustangs named Sally in this race!

Extra Credit: Make your workflow dynamic so it can account for any number of horses.

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!

- The Academy Team

Download Start File | Download Solution File

Qiu

I am the first again?
I wonder we need a macro for the dynamic approach, and I do hope someone can enlight me the approach without a Macro.

Spoiler

alexnajm

@Qiu I'm in the same boat - no idea how to do macros in cloud yet so this is what I got for now - it is dynamic except for the number of Appends

Spoiler

Carolyn

Part 1 solved, but I'm with @Qiu and @alexnajm on Confusion Island for part 2

Part 1:

Spoiler

Part 1 (I changed the Sallys to Sally1 and Sally2 while I was trying to solve part 2, but you can see the RowID Tool in Part 1 which properly handles the duplicates)

Part 2:

Spoiler

For Part 2, I can figure out how many combos there are by doing a factorial. 4! = 24. If there were 5 horses, then there are 120 combos.

From there, I tried doing the Generate Rows to get me 24 lines. Or I took the 4 horses and then generated rows to get 24 * 4 = 96 rows. But then I couldn't figure out how to rearrange the horses properly

I could figure out the first place horse by doing some type of variation of taking total combos divided by total horses (24 / 4 = 6) and then seeing if the ComboID was less than 6 (Horse1 was first), 6-12 (Horse2 was first), 13-18 (Horse3), or 19-24 (Horse4). But then when I tried to find patterns for the 2nd-4th+ places (e.g. if you divide something by something, if the mod is something then that means Horse2 is 2nd), nothing jumped out at me, but that could just be because of how I visualized the patterns

When I Googled, the only answers I found were recursive/iterative

I'll keep thinking on it but I am stumped!

For Part 2, I can figure out how many combos there are by doing a factorial. 4! = 24. If there were 5 horses, then there are 120 combos. From there, I tried doing the Generate Rows to get me 24 lines. Or I took the 4 horses and then generated rows to get 24 * 4 = 96 rows. But then I couldn't figure out how to rearrange the horses properly I could figure out the first place horse by doing some type of variation of taking total combos divided by total horses (24 / 4 = 6) and then seeing if the ComboID was less than 6 (Horse1 was first), 6-12 (Horse2 was first), 13-18 (Horse3), or 19-24 (Horse4). But then when I tried to find patterns for the 2nd-4th+ places (e.g. if you divide something by something, if the mod is something then that means Horse2 is 2nd), nothing jumped out at me, but that could just be because of how I visualized the patterns When I Googled, the only answers I found were recursive/iterativeI'll keep thinking on it but I am stumped!