Alteryx Community is the go-to hub for analytics professionals to learn, connect, and solve problems faster. Explore expert-led discussions, product resources, and best practices to build, automate, and scale your analytics workflows with Alteryx.
A solution to last week’s challenge can be found here. In this challenge, you have a dataset with statistics from men’s singles tennis tournaments around the world. Your task is to determine who won the final with the biggest average rank difference in a tournament that had at least 20 final rounds. To find the answer, use…
Here is a new challenge for this week. The link to the solution for last week’s challenge is HERE. The use case: We received some text data and that includes an embedded line-feed character. The objective is to remove the new line character, convert the date-time string to a date-time formatted field and then do some…
Here is the new weekly challenge. The link to the solution for last challenge is HERE. For this challenge let’s look at ranking records when multiple records can have the same rank. The objective is to determine the top 5 ranking based on the count, however since there are multiple rows with same count (similar to a round…
Hi Community members, A solution to last week’s challenge can be found here. This challenge was submitted by Michael Keiffer, @mkeiffer . Thank you, Michael, for your submission! In this week’s challenge your task is to match each hourly worker’s time-in and time-out entries with the correct pay period end dates. Workers…
A solution to last week’s challenge can be found here. Source: https://www.dailymail.co.uk/news/article-4965690/Humpback-whale-breaches-Sydney-Harbour-sunset.html Every year whales around the world migrate from their feeding grounds to their breeding grounds. Some species travel an outstanding 12,000 miles round trip! Use…
Hi Community members, A solution to last week’s challenge can be found here. This challenge was submitted by John Primeaux (@jeprime) . Thank you, John, for your submission! This week, you’re stepping into the role of a data quality detective. A data table has been populated with critical tracking codes—but many of them…
A solution to last week’s challenge can be found here. Source: www.scantron.com/assessment-solutions/ Who said girls can't do math? It's 2020 and girls are thriving in many math and science areas, including data science. Just check out our Women of Analytics page! In this week's challenge, we have the results from the New…
Hello Community members, A solution to last week’s challenge can be found here. We are back with another exciting challenge, and this one is all about hot sauces! A big thank you to James Gust for creating this spicy challenge! This week’s challenge is the first of two parts. For Part 1, you have a collection of individual…
The solution to last week's challenge is HERE. This week we will be offering our third ever challenge on converting strings to dates. Sometimes these may be simple, but every once in awhile, we come across those source systems that drop things in a format that are better understood by machine than by a human. In this…
Hi Community members, A solution to last week’s challenge can be found here. This challenge was submitted by James Bevan, @JBevan89 . Thank you, James for your submission! For this week’s challenge, we will be working with the TMDB Movie Metadata dataset from Kaggle, a rich collection of information about modern films,…
It looks like you're new here. Sign in or register to get started.
