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.
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…
The link to the solution for last challenge #34 is HERE. For this challenge let’s practice some data cleansing. Use Case: There is a series of data cleansing processes we need to do on our data. Please solve each per the instructions. Objective: * Remove leading zeroes * Trim leading zeroes and/or descriptive text at the…
I have a text field with content such as this "2016-01-30_2.Monthly_P&L". I'd like to parse the field into 4 fields: Year, Month, Date and just a Name field so the fields would be: 2016-01-30_2.Monthly_P&L 2026 01 30 2.Monthly_P&L I used this RegEx expression "(\d+)-(\d+)-(\d+)_(\d+\.\w+\_\w+\&\w+)" but result looked like…
A solution to last week's Challenge can be found HERE. I love that some Challengers submitted a solution using the Image tool. It's just one more reminder that there's almost always more than one way to accomplish a task with Alteryx! I'm sure it comes as no surprise to anyone from Illinois, but the Land of Lincoln gives…
Here at Alteryx we know the importance of growing our experience at solving data and business problems. Almost weekly (~40+ times a year) we share an Alteryx challenge with our internal Alteryx users and then we all develop our own solutions. Later we review our solutions in small groups. Since many Alteryx users have…
A solution to last week's Challenge can be found here! A big thanks to those of you that joined us last week at Inspire for the Weekly Challenge session! It was so much fun solving with you all! This week, we're identifying the most popular baby names that were registered between the years of 1880 and 2017. Given the…
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 this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #10 is HERE. The use case: A manufacturing company receives customer complaint data on a daily basis from their call centers about the medical parts they distribute to their…
A group of friends are playing their favorite game. Not being a bunch of data analysts and understanding the importance of inputting data in an easy to work with way, they devised an incredibly inefficient way to keep score of their game! In the game, there is 5 rounds of play and 5 players (a,b,c,d,e - first letter of…
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…
It looks like you're new here. Sign in or register to get started.
