Cloud Quest #47: Thanksgiving Feast

[AYXAcademy]

 

Hi Community,

We posted the solution JSON file to Cloud Quest #46. 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 ZIP file containing your starting data and workflow files.
2. Upload Start Cloud Quest 47.json to your Alteryx One library.
3. Reconnect Quest47Input.csv to the Input Data tool in your starting workflow.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.

 

Scenario:

For this week’s Thanksgiving holiday themed Cloud Quest, you’ll take a look at what dishes people typically serve in different US regions.

The dataset contains information about the types of dishes served at Thanksgiving dinners in US households. The columns include type of protein, cranberry, gravy (yes/no), type of sides, pies, dessert, and the US region they are located in.

Task 1: Find the total number of food dishes (protein, cranberry, gravy, sides, pies, and dessert) served in each household.

Task 2: Find the average number of dishes served for each US region.

Task 3: Calculate what percentage of total pies comes from each region.

Task 4: Determine the most popular combination of side dishes, and how many households are serving it.

Hint: You can use the Text to Columns tool to “pivot” concatenated values to rows

Image: Generated by Google Gemini, Nov 24, 2025, https://gemini.google.com.

 

Earn Cloud Quest badges:

After completing your quest, head back to your Analytics Cloud library:

• Download your workflow solution file.
• In your reply, attach both your JSON solution file and a screenshot of your workflow.
• Keep submitting—every solution gets you closer to earning more Cloud Quest badges!

 

Here’s to a successful quest!

- The Academy Team

Download Start File | Download Solution File

[Qiu]

I can not match my solution with the provided ones except for question#1, I would like to see others take so I can knwo where goes wrong in mine. 😂

[RWvanLeeuwen]

Here's my take on this cloud quest:

Spoiler

[RWvanLeeuwen]

Hi @Qiu You can use my solution to compare, but then again I have some slight differences for Task 3 so perhaps my output is somehow fundamentally different to what is required, so let's see what others come up with :-)

[Qiu]

@RWvanLeeuwen 

Thank you very much.

I had to go back up weekly challeng #295 to see what I did back then. 😁

Spoiler

Our results for #3 are actually same so I will go with it.
 

[RWvanLeeuwen]

Great topic to start here! 

I took liberty in sharing links and screenshots:

Spoiler

I found your message as well M70513 

and a long time afterwards came in my post with the following  and here is the link to my message M89202
image wasnt posted back then due to bugs in the community messaging system but I retrieved it:
I notice that I was using many more tools back then, but the initial Transpose Tool approach has been the same.

[alexnajm]

Done!

Spoiler

[RolandSchubert]

Spoiler

[bradshaw]

Spoiler

 

[AkimasaKajitani]

My solution!

I got task 3 output to match perfectly.

Spoiler

Task 3 solution output contains blank pies. So if you want to match them, you have to count all pies with empty items.
However, I don't think there should be any empty rows.