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.
I would like to extract the identities/locations of sanctioned entities from the U.S. Sanctioned List Service. OFAC Specially Designated Nationals List - Sanctions List Service This XML document marks sanctioned entities with the <entity id="12345"> tag, and often under it are variations of the name, identified by <"name…
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 #33 is HERE. For this chalenge let’s look at creating a macro from scratch. I recommend you first solve the problem with tools on the canvas, then cake a macro from the tools.…
The link to last week’s challenge (challenge #21) is HERE. This week’s challenge is a little special. I have mentioned before that as internal users or Alteryx we all do these exercises every week and we started doing this at the beginning of 2014. There have been a lot of exercises since then and the product has changed a…
Welcome to Week 75!! We have a few people vying for a new shiny badge!! This challenge is based off the word game Scrabble. In the game of Scrabble, you are given 7 tiles with a letter printed on them. Additionally, a point value is assigned to the letters. The player tries to find the word that is worth the most points.…
A solution to last week's Challenge has been posted HERE! I learned the worst thing to say to a bunch of football fans: "The Super Bowl? It's just another football game". The looks of horror on my colleagues' faces when I said that are burned into my memory forever. And let me warn you: don't say that when you have…
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…
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…
A solution to last week’s challenge can be found here. Are you wondering which artists produced the top songs? Do you want some insights? This challenge is for you. The following dataset contains information about the top 500 songs. Using the dataset, find the top 50 artists with the most albums and the highest average…
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…
A solution to last week’s challenge can be found here. The Eurovision Song contest or Eurovision is an annual song competition in Europe. During a live show, contestants representing European countries, sing a song and receive points. The contestant with the most points wins. In 1974, the Swedish group ABBA became a…
It looks like you're new here. Sign in or register to get started.
