This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret. In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.
Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output.
You may notice that we have started classifying the exercises into beginner, Intermediate and advanced. This classification is used by Alteryx internally to sequence exercises as users advance.
The solution has been uploaded.
... View more
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 expressed an interest in having us share these exercises, we have created this new section of the Community. The intent is to share and exercise about once a week on Monday. Some of the exercises will be easy and some you will find more challenging. The goal is to expose everyone to more of the things Alteryx can do and hopefully everyone will take away an idea or two on how to approach different challenges. The following week we will post a new challenge as well as an example solution to the previous week's challenge.
We hope you enjoy the exercises.
Exercise #1 Join to Range:
A company in Australia has source data which is made up of a series of postal codes (eg. 2000, 2001, 2002 etc.) amongst some other data fields. They have a separate reference table which contains postcode ranges (eg. 2000 to 2002) which they would like to use to match/filter their main data.
Each Customer Record needs to be joined to the Lookup table based on a Postal Area Ranged region. Then finally summarize the customer data by Region, Sales Rep, and Responder, then a count of customers.
Check and see what the result should look like by looking at the data labeled 'Output'. Your mission is to take the input files and blend them so your result matches the output shown. Good luck!
I have posted a solution to challenge #1 from last week. It is a good example to show the usefulness of the generate rows tool. Please keep in mind that this is just one solution using Alteryx to solve the problem, there can be many other solutions and approaches to the problem. Hopefully you had fun and learned something new in the process.
... View more
A solution to last week’s challenge can be found here.
This week's challenge is relatively straightforward, but sometimes data needs trimming.
The following dataset includes a list of city, country, year, continent, and season (winter or summer)
for each Olympic Games except those canceled.
Your challenge is to find: - How many times has each continent hosted the Summer Olympics? - How many times has each continent hosted the Olympic Winter Games? - What is the total of the Olympic Games hosted for each continent, summer and winter combined?
Oh, easy, you may think. For this Challenge, you will have to propose 2 solutions and one that does not use the trim functions.
... View more
A solution to last week's challenge can be found here. Source: https://en.wikipedia.org/wiki/Belmont_Stakes
This week's challenge was submitted by @mst3k - Thank you for your submission!
Later this week, the Belmont Stakes will be held in New York. If you are unfamiliar, this is a famous horse race which serves as the third race in the Triple Crown (the Kentucky Derby and Preakness are the other two legs). While there will not be a triple crown winner this year (since different horses won the previous two legs), we can still have some fun analyzing some race possibilities!
A race is being held between 4 horses. Create an output of every possible combination of race finishes. No horse should be able to finish in more than 1 place, but be warned there are two *different* mustangs named Sally in this race! Extra Credit: If there are 5 horses instead of 4, how many possible outcomes are there? Can that number be generalized if there are n number of horses?
... View more
The link to last week’s challenge ( challenge #19) is HERE. For this week’s challenge we need to clean up an unformatted text file with unstructured data.
Use Case: A sales executive got a series of leads from the DMA conference. Unfortunately it’s a text file that we want to restructure into a tabular form to load into Salesforce.
The result should be a table formatted the same as the output sample.
As always there are many ways to approach the same problem in Alteryx. I am looking forward hear about some of your solutions.
... View more