Cloud Quest #11: Filtering Sports News

[AYXAcademy]

Hi Maveryx,

We posted the solution JSON file to Cloud Quest #10. 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 11 - Start File.json file into your Analytics Cloud library.
3. Reconnect the provided NY Times Data.csv dataset 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:

In today’s Cloud Quest, you will find a dataset containing the titles, key words, and other data for all New York Times articles published from January 1, 2020, to December 31, 2020.

1. Your first task is to identify which day of the week has the highest number of articles published in the Sports section.
2. Your second task is to identify how many times the word "Football" or "football" appears in the headline or keywords on the day of the week with the highest number of articles published in the Sports section.

In your result, write a statement similar to this:

The word football appears [number] times in articles published in the Sports section on [day of week]s.

Hint: Unlike Designer Desktop, the Text To Columns tool in Designer Cloud requires the backslash character (\) to be used to escape values within strings. White space characters can be escaped with a backslash as they are in RegEx syntax. You can find more information in the Delimiters field in the Text To Columns tool's Configuration window.

Spoiler

A combination of the Filter, Summarize, Formula, Text To Columns, and Join 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 Maveryx 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!

[prabhakaran5]

Spoiler

[mshishido]

here it is

[ggruccio]

Fun and easy!

Spoiler

[TonyaS]

This is what happens when I do not take any hints, it may be ugly but it does the job. :) 
And I created an App in App Builder for extra credit. 

Spoiler

[mceleavey]

Nice and straightforward, but ensure you make the necessary bits and pieces dynamic.

Spoiler

I first filtered down to those records containing "Sports" in the section column, then created the day of the week using DateTimeFormat(left([pub_date],10),"%A") in a formula.
I then took one stream into a Sum tool and counted the number of day occurrences, sampled the first one sorted by number descending, this gave me my first answer, then joined back on Day.
From there I made the "keywords" and "headline" columns uppercase and filtered for football. Then it was a simple summarise and a formula for the statement using those dynamic elements of count and day.

M.

[Shelbey]

Spoiler

[Smatthias]

Spoiler

SPOILER

Filtern for football, then parsed the word football out, so I could count it,the rest is simple math and a string.Quest11_matthias

[tshih18]

Spoiler

 

[patrick_digan]

Spoiler

[smurfitt]

Hi Please find my solution attached,  I believe the word football appears more times that the solution states, the solution seems to have the number of articles with the word football rather than the actual number of times that football appears..  I was able to match the solution, but added the correct to the end of the output..  

Let me know if I missed something,   

Thank you