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.
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…
We hope you enjoyed last week's challenge. The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters. Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control…
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…
The link to last week’s challenge (challenge #20) is HERE. For this week’s challenge we have an easier one that requires the reformatting date fields. The input data has very poorly formatted month and year information that will require you to build some logic to make it usable. Use Case: A company needs to reformat a…
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…
Hi Community members, A solution to last week’s challenge can be found here. This challenge was submitted by Ashley Talay, @aatalai. Thank you, Ash, for this delightful seasonal puzzle! As the snow begins to fall and the year comes to a cozy close, it’s the perfect time for a bit of holiday fun. While the Elf on the Shelf…
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…
Hi Maveryx, A solution to last week’s challenge can be found here. Don't forget that we are running a campaign inviting all of you to contribute to our upcoming 2024 Weekly Challenges! Your ideas and participation are crucial in shaping an engaging and innovative year ahead. Visit our blog post to review the guidelines and…
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.
