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're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackWelcome to the Weekly Challenge. Each week we will post a use case where you can put your Alteryx skills to the test. You'll be able to share your answers and collaborate with other challengers to arrive at an answer. Participation will be rewarded - just make sure you are attaching your Alteryx workflows to your responses!
Interested in keeping track of which challenges you have completed?
Download this workflow
created by @Hannah_Lissaman, @Alekh, and @mceleavey.
or try this app
to download your unsolved challenges. (Created by: @LordNeilLord)
Top Challengers (2021-03-02):
Rank | Challenger | Challenges Completed |
1 | @AkimasaKajitani, @Kenda, @PhilipMannering, @RolandSchubert, @patrick_digan | 257 |
2 | @OllieClarke, @TonyA, @ggruccio, @mbogusz, @rmassambane | 256 |
3 | @JennyMartin, @RichoBsJ, @atcodedog05 | 254 |
4 | @AngelosPachis, @dsmdavid | 253 |
5 | @JosephSerpis | 252 |
6 | @hanykowska | 251 |
7 | @Jonathan-Sherman, @T_Willins, @jasperlch | 249 |
8 | @kelly_gilbert | 248 |
9 | @JoshuaGostick | 246 |
10 | @SeanAdams | 244 |
Top Solvers in the Last 30 Days:
Rank | Challenger | Challenges Completed |
1 | @BeginnerMindset, @RH0258 | 70 |
2 | @ricardocarog | 62 |
3 | @apathetichell | 61 |
4 | @Toons | 54 |
5 | @binuacs | 50 |
6 | @Hub119 | 35 |
7 | @mot | 34 |
8 | @lukecornetta | 30 |
9 | @Eilean_ | 28 |
10 | @JP_SDAK | 27 |
# | Challenge Name | Level of Difficulty | Main Subject |
1 | Join to Range | Intermediate | Data Preparation |
2 | Preparing Delimited Data | Beginner | Data Parsing |
3 | Running Averages | Intermediate | Data Preparation |
4 | Date Parsing | Advanced | Data Parsing |
5 | HR Position Finder Application | Intermediate | Apps |
6 | Spatial Route | Intermediate | Spatial |
7 | Download Data and Parse JSON | Advanced | Data Parsing |
8 | Aggregate Consumer Purchases | Beginner | Data Analysis |
9 | Analytics Ranking | Beginner | Data Analysis |
10 | Date Time Calculations | Intermediate | Data Analysis |
11 | Identify Logical Groups | Intermediate | Data Analysis |
12 | Creating an HR Hierarchy | Advanced | Macros |
13 | HTML Table Parsing | Advanced | Data Parsing |
14 | Warehouse Distribution | Intermediate | Macros |
15 | Warehouse Shipped Miles | Beginner | Spatial |
16 | Parsing Out the New-line Character | Beginner | Data Cleansing |
17 | Month-over-Month Retention Rate | Advanced | Macros |
18 | Predicting Baseball Wins | Intermediate | Predictive |
19 | Excel Record Locator | Beginner | Data Cleansing |
20 | List Parsing | Advanced | Data Preparation |
21 | Date Reformatting | Beginner | Data Cleansing |
22 | Identify Values to Aggregate | Intermediate | Data Parsing |
23 | Parsing CPG Data | Advanced | Data Parsing |
24 | ARIMA Time Series | Intermediate | Predictive |
25 | Creating Merchant Combos | Intermediate | Data Analysis |
26 | Service Technician Travel Distance | Beginner | Spatial |
27 | Spatial Telco Coverage Smoothing | Intermediate | Spatial |
28 | Formatting Financial Data | Intermediate | Data Cleansing |
29 | Alteryx '16 Grand Prix (Race1, L1) | Intermediate | Data Preparation |
30 | Alteryx '16 Grand Prix (Race 1, L2) | Beginner | Data Analysis |
31 | Alteryx '16 Grand Prix (Race 2, L1) | Intermediate | Data Preparation |
32 | Alteryx '16 Grand Prix (Race 2, L2) | Intermediate | Spatial |
33 | Reshaping Nielsen Data | Intermediate | Data Preparation |
34 | Date-Time Formatting | Advanced | Macros |
35 | Data Cleansing Practice | Beginner | Data Cleansing |
36 | Data Cleansing Extract Authors | Intermediate | Data Parsing |
37 | Parsing a Raw XML File | Intermediate | Data Parsing |
38 | Data Blending for Batch Output | Beginner | Data Preparation |
39 | Trouble Shooting a Broken Macro | Intermediate | Macros |
40 | Parsing a HTML File | Intermediate | Data Parsing |
41 | Analytics PayPeriodCalc | Beginner | Data Analysis |
42 | Inspire Europe '16 Grand Prix (L1) | Intermediate | Data Analysis |
43 | Inspire Europe '16 Grand Prix (L2) | Intermediate | Data Analysis |
44 | Inspire Europe '16 Grand Prix (L3) | Intermediate | Data Analysis |
45 | Parsing Bureau of Labor Data | Advanced | Data Parsing |
46 | Formatting a Date from an Integer | Beginner | Data Preparation |
47 | Vehicle Identification Number Test | Intermediate | Data Preparation |
48 | Calculating Distribution Priority | Intermediate | Spatial |
49 | Reformatting Transactional Data | Beginner | Data Preparation |
50 | Preparing Survey Data | Advanced | Data Analysis |
51 | Spatial County Coverage | Intermediate | Spatial |
52 | Solving the Knapsack Problem | Advanced | Data Analysis |
53 | Parsing Report Formatted Data | Intermediate | Data Parsing |
54 | Data Prep Address Parsing | Beginner | Data Parsing |
55 | 2013 Alteryx Grand Prix (L1) | Intermediate | Data Analysis |
56 | Parsing and Counting Hashtags | Intermediate | Data Analysis |
57 | Build a Valentine's Day App | Intermediate | Apps |
58 | An Odd String to Date Conversion | Beginner | Data Preparation |
59 | Is it an Anagram? | Intermediate | Data Analysis |
60 | Fill in the Spatial Object | Intermediate | Spatial |
61 | Save the Astronaut | Advanced | Data Analysis |
62 | Find the Duplicate Clicks | Intermediate | Data Analysis |
63 | Data Preperation Using Pivot Tools | Intermediate | Data Preparation |
64 | Catch Me If You Can | Intermediate | Data Preparation |
65 | Fulfilling Inventory Orders | Beginner | Data Analysis |
66 | My Wine Problem | Intermediate | Macros |
67 | Calculate Spatial Angles | Intermediate | Spatial |
68 | Elapsed Classroom Times | Beginner | Data Analysis |
69 | Web Stock Data | Beginner | Data Parsing |
70 | Trade Area Drivetime Radii | Beginner | Spatial |
71 | Recreate SQL Joins in Alteryx | Intermediate | Data Preparation |
72 | Compare Data Sets (Fields/Columns) | Intermediate | Data Preparation |
73 | Plinko Probabilities | Advanced | Data Analysis |
74 | Build a Factorial Calculator | Beginner | Macros |
75 | Scrabble Word Finder | Advanced | Data Preparation |
76 | Strava Export Parse and Report | Intermediate | Data Parsing |
77 | Extending Spatial Lines | Intermediate | Spatial,Macros |
78 | Find the Best Housing Markets | Intermediate | Data Parsing |
79 | Find the Closest Prime Number | Intermediate | Apps |
80 | Slowly Changing Dimensions | Intermediate | Data Preparation |
81 | Multi-Level Bill of Materials Problem | Intermediate | Data Analysis |
82 | Are You in the Path of the Solar Eclipse? | Intermediate | Spatial |
83 | Pop-Tart and Beer Pairings | Intermediate | Data Preparation |
84 | Map Hurricane Harvey's Storm Evolution | Intermediate | Spatial |
85 | How Did Tara Place in Competition? | Intermediate | Data Analysis |
86 | Create a Macro that Generates Past Dates | Advanced | Macros |
87 | Losing Daylight | Beginner | Data Analysis |
88 | Counting Combinations | Beginner | Data Analysis |
89 | Analyzing Social Data | Beginner | Data Analysis |
90 | Analyzing Social Data (Part 2) | Intermediate | Data Analysis |
91 | Getting into the Weeds | Advanced | Apps |
92 | The Blob! | Beginner | Data Parsing |
93 | Pumpkin Production | Beginner | Data Analysis |
94 | Have we reached Peak Pumpkin? | Advanced | Predictive |
95 | Draw 1000 Apples in Under 60 Seconds | Advanced | Spatial |
96 | Who Stole my Latte? | Intermediate | Data Preparation |
97 | SANTALYTICS 2017 - Part 1 | Intermediate | Data Preparation |
98 | SANTALYTICS 2017 - Part 2 | Intermediate | Data Analysis |
99 | SANTALYTICS 2017 - Part 3 | Advanced | Data Analysis |
100 | Find Ned! | Advanced | Spatial |
101 | The Search for Powder | Intermediate | Data Analysis |
102 | Tabulating Flu Data | Beginner | Data Preparation |
103 | Just another game? | Advanced | Predictive |
104 | Love's not the only thing in the air! | Beginner | Data Analysis |
105 | Think Like a CSE… Tools are missing! | Intermediate | Macros |
106 | How Long were the Lights On? | Beginner | Data Analysis |
107 | Plot Employment Rates by Gender in the US | Advanced | Data Analysis |
108 | HeLa Cell Multiplication | Intermediate | Data Analysis |
109 | Women in Government Around the World | Intermediate | Data Preparation |
110 | Think Like a CSE...Reduce the manual inputs! | Intermediate | Apps,Macros |
111 | Make a Weekly Challenge Dream Team! | Advanced | Data Analysis |
112 | Organizing Survey Data | Intermediate | Data Preparation |
113 | Interpolating Spatial Grid Values | Advanced | Spatial |
114 | Think Like a CSE...Remove the extra delimiter from the JSON output | Intermediate | Data Preparation |
115 | Let's get crafty! | Intermediate | Apps |
116 | A Symphony of Parsing Tools! | Advanced | Data Parsing |
117 | Credit/Debit Midpoints | Intermediate | Data Analysis |
118 | Think Like a CSE - A not-so-wild-wildcard input! | Intermediate | Data Preparation |
119 | Inspire Weekly Challenge | Intermediate | Data Analysis |
120 | Popular Baby Names | Beginner | Data Analysis |
121 | World Cup 2018! | Beginner | Data Cleansing |
122 | Think Like a CSE...Ranking Data | Intermediate | Data Analysis |
123 | When will Rabbits Rule the World? | Intermediate | Data Analysis |
124 | Air Transport Network Analysis | Advanced | Predictive |
125 | US Grand Prix Lap 1 - Data Prep | Beginner | Data Preparation |
126 | Fill in the [Date] Gaps | Intermediate | Data Preparation |
127 | US Grand Prix Lap 2 - Employee Retention | Intermediate | Predictive |
128 | Settle the Score | Beginner | Data Analysis |
129 | US Grand Prix Lap 3 - Where to Host an Event | Intermediate | Spatial |
130 | Is There an Echo in Here? | Intermediate | Data Parsing |
131 | Think Like a CSE... The R Error Message: cannot allocate vector of size... | Advanced | Predictive |
132 | When Will Community Hit 1,000,000 Posts? | Intermediate | Predictive |
133 | US Grand Prix Prelims - NASA Location Analysis | Intermediate | Spatial |
134 | US Grand Prix Prelims - Email Dates | Intermediate | Data Cleansing |
135 | Locker Problem | Intermediate | Macros |
136 | Cleudo! | Advanced | Data Analysis |
137 | Find the Closest 'Dry' Point! | Beginner | Spatial |
138 | World Series Wins | Beginner | Data Analysis |
139 | Spooky API Connection | Intermediate | Data Analysis |
140 | Prove the Birthday Paradox! | Intermediate | Data Analysis |
141 | Examination Data Simulation | Advanced | Data Analysis |
142 | Life Certainties - Workflows, Death, and Taxes | Beginner | Data Preparation |
143 | Developer Community Anniversary Edition | Advanced | Macros |
144 | Secret Santa Assignments (BAH HUMBUG!) | Beginner | Data Analysis |
145 | SANTALYTICS 2018 - Part 1 | Beginner | Data Analysis |
146 | SANTALYTICS 2018 - Part 2 | Intermediate | Data Analysis |
147 | EMEA Grand Prix Prelims - Time Series | Intermediate | Predictive |
148 | Rotating Century Puzzle | Advanced | Data Analysis |
149 | Market Overlap | Intermediate | Spatial |
150 | Have the Stars Aligned?! | Intermediate | Data Analysis |
151 | Meta Parsing | Intermediate | Data Parsing |
152 | Finding Vehicle Counts | Intermediate | Data Cleansing |
153 | And the Oscar goes to... | Intermediate | Apps |
154 | Permute the Data | Advanced | Data Analysis |
155 | March Cryptanalytics | Intermediate | Data Analysis |
156 | What Position Should You Play? | Intermediate | Data Parsing |
157 | An Expert Challenge | Advanced | Predictive |
158 | Personality Quiz | Intermediate | Apps |
159 | April ENcyptanalytics | Advanced | Data Preparation |
160 | Diamonds R Forever | Advanced | Data Analysis |
161 | Triangles, Triangles, Triangles | Intermediate | Spatial |
162 | Mondays....they're Marvel-ous! | Intermediate | Data Preparation |
163 | Caesar Cipher (on the way to Kryptos) | Intermediate | Data Analysis |
164 | Retail Therapy | Beginner | Data Analysis |
165 | KRYPTOS!!! | Advanced | Data Analysis |
166 | I'm Gonna Be (500 Miles) - at Inspire | Intermediate | Spatial |
167 | Grand Prix 2019 | Beginner | Data Preparation |
168 | Dice Game - Born to Solve | Intermediate | Data Analysis |
169 | Women's World Cup Wins | Beginner | Data Analysis |
170 | 2019 Grand Prix US - Heat 1 | Intermediate | Predictive |
171 | 2019 Grand Prix US - Heat 2 | Intermediate | Data Analysis |
172 | 2019 Grand Prix US - Heat 3 | Intermediate | Spatial |
173 | Tour de France - Crow Edition | Beginner | Spatial |
174 | Appyhay Ondaymay! | Intermediate | Data Preparation |
175 | Tire Size Calculator | Advanced | Apps |
176 | Math Class Drill | Intermediate | Data Analysis |
177 | Ham Hamlet | Advanced | Data Analysis |
178 | Chuck Like a Woodchuck | Beginner | Data Analysis |
179 | Calculating Order Status | Intermediate | Data Analysis |
180 | Thousand File Challenge | Advanced | Macros |
181 | Ingredients of an Old Southern | Intermediate | Data Parsing |
182 | Word Sleuthing | Beginner | Data Parsing |
183 | Roman Numeral Math | Advanced | Data Analysis |
184 | Closest Pubs to Tobacco Dock | Intermediate | Spatial,Data Analysis |
185 | Amplify your Learning with Weekly Challenges! | Intermediate | Data Analysis |
186 | Drilling down into Data Analysis | Intermediate | Data Analysis |
187 | Generate Prime Numbers | Intermediate | Data Analysis |
188 | Difficult, but not im-parse-able | Advanced | Data Parsing |
189 | Billboard Top 100 | Beginner | Data Preparation |
190 | Supply Chain Management Challenge | Intermediate | Data Analysis |
191 | BINGO! | Advanced,Beginner,Intermediate | Data Preparation |
192 | Crane Leasing | Intermediate | Data Analysis |
193 | Unofficial Holidays | Beginner | Data Preparation |
194 | SANTALYTICS 2019 | Beginner | Data Analysis |
195 | XML Parsing | Advanced | Data Parsing |
196 | Determine Profit Margin | Intermediate | Data Preparation |
197 | Customer Density Reporting | Intermediate | Data Analysis |
198 | Beverage Inventory | Intermediate | Data Preparation |
199 | Let's all go to the movies! | Intermediate | Spatial |
200 | Sudoku Solver | Advanced,Beginner,Intermediate | Data Analysis |
201 | Wage Ain't Nothin' but a Number | Intermediate | Data Analysis |
202 | Love Poetry | Intermediate | Apps |
203 | Everyone loves a toll booth | Intermediate | Data Analysis |
204 | Updating Brazil | Intermediate | Spatial |
205 | Taynalysis | Beginner | Data Preparation |
206 | Hotel Reservations | Beginner | Data Preparation |
207 | Parsing Video Game Data | Intermediate | Data Parsing |
208 | COVIZ-19 | Advanced | Data Analysis |
209 | Parsing Insurance Claims | Advanced | Data Parsing |
210 | Better Late Than Never | Intermediate | Data Parsing |
211 | Generating Email Addresses | Beginner | Data Preparation |
212 | Draft Masters | Beginner | Data Preparation |
213 | Optimized Flower Arrangements | Intermediate | Predictive |
214 | US Military and High Points | Intermediate | Data Analysis |
215 | Gotta Catch 'em All! | Intermediate | Apps |
216 | The Big Five | Intermediate | Data Analysis |
217 | A Fast Blast From The Past | Intermediate | Data Analysis |
218 | Car Sales Reporting | Intermediate | Data Analysis |
219 | Who Runs The World? Girls | Beginner | Data Preparation |
220 | Hedge Detection | Advanced | Spatial |
221 | Avocado Consumption | Intermediate | Data Analysis |
222 | Where There's a Whale There's a Way | Beginner | Data Analysis |
223 | Going Nuclear | Intermediate | Data Analysis |
224 | Mushroom for Improvement | Intermediate | Data Preparation |
225 | How Long Has It Been? | Intermediate | Apps |
226 | Flex-Ability | Beginner | Spatial |
227 | /*comments*/ | Intermediate | Data Preparation |
228 | Know Your Boundaries | Advanced | Spatial |
229 | Trend Analysis | Intermediate | Data Analysis |
230 | Take a Look, It's in a Book! | Intermediate | Data Preparation |
231 | What a Combo! | Intermediate | Data Analysis |
232 | That's Sew 2020 | Beginner | Data Analysis |
233 | The Truth Is Out There | Intermediate | Data Analysis |
234 | Spell It Out For Me - Part 1 | Intermediate | Data Preparation |
235 | Spell It Out For Me - Part 2 | Intermediate | Data Preparation |
236 | I Thought It Was Channel Surfing? | Intermediate | Spatial |
237 | Wareki | Intermediate | Macros |
238 | Ideal Gases Don't Exist | Intermediate | Apps |
239 | SEND + MORE = MONEY | Intermediate | Data Analysis |
240 | Every Vote Counts! | Intermediate | Macros |
241 | Friday the 13th | Beginner | Data Preparation |
242 | Meet Me Halfway | Intermediate | Spatial |
243 | Odd Man Out | Beginner | Data Preparation |
244 | Cats and Dogs | Intermediate | Data Analysis |
245 | Zip It Real Good | Intermediate | Data Preparation |
246 | Rectangle Tangle | Intermediate | Macros |
247 | Pairing Partners | Intermediate | Data Preparation |
248 | Holidates | Beginner | Data Analysis |
249 | Highlights | Beginner | Data Analysis |
250 | Give Me A Sign | Advanced | Apps |
251 | Lunacy | Advanced | Spatial |
252 | Working Days Remaining | Intermediate | Macros |
253 | Delivery Dates | Beginner | Data Analysis |
254 | DATA-DRIVEN COCKTAIL RECIPE - PART 1 | Intermediate | Predictive |
255 | DATA-DRIVEN COCKTAIL RECIPE - Part 2 | Intermediate | Predictive |
256 | Working Fore The Weekend | Beginner | Data Analysis |
257 | Palindromes | Intermediate | Macros |
This is ridiculously helpful - thank you @JoeM. 🙂
Hope it's not too much of a pain to maintain - since it provides such a useful single-stop place to reference these exercises without having to search all the various posts on the board.
This is a very helpful list. Thanks a lot for taking the effort.
Subrat
I have been unable to open the start files for most challenges since week 61. In my Corporate environment we are on Alteryx 10.5.9, and we have no option to upgrade until our corporate IT department decides it is ready.
Could the challenge start files be posted in a format that can be opened with 10.5?
Thanks JoeM!
Hey @JoeM - thank you for our weekly dose of brain-candy - gonna tackle #68 now!
How would you feel about gathering the good folks at Alteryx, to come up a weekly challenge that forces us to use some of the tools that are languishing in the toolbox just waiting to be invited to this great party? Something slightly mean, that makes people have to have a second (and perhaps even a third) coffee before they can get through it?
I'm thinking, for example, of setting a challenge that requires the use of the Calgary tools, or even some of the developer tools (perhaps there's something fiendish that the team could come up with to force the community to engage with all the Blob tools under the developer tab), or if you wanted to be really mean then perhaps the XML extensions to functions?
🙂 Thank you again for the work that goes into this Joe - it really is one of the most useful ways for me to learn, and I know that a lot of people feel this way!
Have a good Tuesday
Sean
Seriously though, I have some sitting around that we could use. However, we have some challenges coming down the pipe from "Big Data" Matt (@MattD) this May , so I can start throwing out some more difficult ones in June!