Cloud Quest #18: Holidays Down Under

[AYXAcademy]

Hi Community!

We posted the solution JSON file to Cloud Quest #17. 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 18 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:

You work for a company that has offices in the US and Australia. You want to produce a list for staff to reference when either office is closed for a government holiday so they will know not to expect communications that day.

In the US, if a holiday falls on a Saturday, offices will be closed the preceding Friday. If the holiday falls on a Sunday, employees will have the following Monday off.

In Australia, if a holiday falls on either Saturday or Sunday, employees will have the following Monday off.

Using the provided datasets of US and Australian (AUS) holidays in 2024, complete the following tasks:

1. Produce a table that lists the date, day of the week, and name of the 2024 holidays for both offices.
2. Determine the total number of business days in Australia and the US in 2024.

Hint: Create a Text Input tool with the Start Date (2024-01-01) and End Date (2024-12-31) and add a Generate Rows tool to establish a list of all calendar dates in 2024.

Spoiler

A combination of the Summarize, Filter, Find Replace, Formula, Join Multiple, and Generate Rows 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 the 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!

[alexnajm]

Fun challenge! Did anyone else get a different number of US business days?

Spoiler

I got 252 instead of 254 for the US

[AkimasaKajitani]

My solution!

Spoiler

US result is different from the sample answer.

Spoiler

[AYXAcademy]

@alexnajm  @AkimasaKajitani you are both correct! Thank you for the catch. When designing the original solution, 2 duplicate records snuck into the US business day schedule. This has been corrected and a new start file has been attached to this quest. Thanks again.

- Academy

[patrick_digan]

Spoiler

[geoff_zath]

Spoiler

 

[Qiu]

Fun challenge

Finally we have Generate Rows tool and that is a lot of holidays. 😁

Spoiler

[RWvanLeeuwen]

Spoiler

[ggruccio]

Fun challenge!  DateTime Parse tool is helpful here!

Spoiler

[JeffF]

Spoiler