Weekly Challenge

JoeM · ‎02-28-2017

Welcome 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 (2022-08-09):

Rank	Challenger	Challenges Completed
1	@AkimasaKajitani, @Kenda, @PhilipMannering, @RolandSchubert, @TonyAndriani, @Watermark, @patrick_digan	331
2	@LiuZhang, @Qiu	330
3	@mmontgomery	329
4	@scoles0617	327
5	@atcodedog05	326
6	@rmassambane	322
7	@binuacs	315
8	@TonyA	312
9	@kelly_gilbert	311
10	@AngelosPachis, @dsmdavid	309

Top Solvers in the Last 30 Days:

Rank	Challenger	Challenges Completed
1	@MilindG	70
2	@SkomantasTamulaitis	69
3	@Brian32	65
4	@JamesCharnley	58
5	@martinding	54
6	@Albert_Vega	51
7	@ahsanaali	47
8	@acarter881	46
9	@sgreenough	44
10	@CHarrison	38

#	Challenge Name	Level of Difficulty	Main Subject
1	Join to Range	Intermediate	Parse,Preparation,Join,Data Preparation,Transform
2	Preparing Delimited Data	Basic	Parse,Preparation,Data Preparation
3	Running Averages	Intermediate	Parse,Preparation,Join,Data Preparation,Transform
4	Date Parsing	Difficult	Parse,Preparation,Data Analysis
5	HR Position Finder Application	Intermediate	Preparation,Join,Transform,Apps,Interface
6	Spatial Route	Intermediate	Spatial Analysis,Spatial,Preparation
7	Download Data and Parse JSON	Difficult	Parse,Preparation,Data Analysis,Developer,Transform
8	Aggregate Consumer Purchases	Basic	Preparation,Data Analysis,Join,Transform
9	Analytics Ranking	Basic	Preparation,Data Analysis
10	Date Time Calculations	Intermediate	Preparation,Data Analysis
11	Identify Logical Groups	Intermediate	Parse,Data Analysis,Join,Transform
12	Creating an HR Hierarchy	Difficult	Preparation,Join,Macros,Interface
13	HTML Table Parsing	Difficult	Parse,Preparation,Data Analysis,Transform
14	Warehouse Distribution	Intermediate	Preparation,Join,Transform,Macros
15	Warehouse Shipped Miles	Basic	Spatial Analysis,Spatial,Preparation,Join,Transform
16	Parsing Out the New-line Character	Basic	Parse,Preparation,Data Preparation
17	Month-over-Month Retention Rate	Difficult	Parse,Preparation,Join,Transform,Macros,Interface
18	Predicting Baseball Wins	Intermediate	Data Investigation,Preparation,Predictive,Join,Transform,Predictive Analysis
19	Excel Record Locator	Basic	Preparation,Data Analysis,Transform
20	List Parsing	Difficult	Parse,Preparation,Data Analysis,Transform
21	Date Reformatting	Basic	Preparation,Data Analysis,Data Preparation
22	Identify Values to Aggregate	Intermediate	Parse,Preparation,Data Preparation,Transform
23	Parsing CPG Data	Difficult	Preparation,Data Analysis,Join,Transform
24	ARIMA Time Series	Intermediate	Preparation,Time Series,Join,Transform,Predictive Analysis
25	Creating Merchant Combos	Intermediate	Preparation,Join,Data Preparation,Transform
26	Service Technician Travel Distance	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Transform
27	Spatial Telco Coverage Smoothing	Intermediate	Spatial Analysis,Spatial,Preparation,Transform
28	Formatting Financial Data	Intermediate	Preparation,Data Analysis,Developer,Join,Data Preparation
29	Alteryx '16 Grand Prix (Race1, L1)	Intermediate	Preparation,Developer,Join,Data Preparation
30	Alteryx '16 Grand Prix (Race 1, L2)	Basic	Data Investigation,Preparation,Data Analysis,Join,Transform
31	Alteryx '16 Grand Prix (Race 2, L1)	Intermediate	Preparation,Developer,Join,Data Preparation
32	Alteryx '16 Grand Prix (Race 2, L2)	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Transform
33	Reshaping Nielsen Data	Intermediate	Preparation,Join,Data Preparation
34	Date-Time Formatting	Difficult	Parse,Preparation,Macros,Interface
35	Data Cleansing Practice	Basic	Parse,Preparation,Data Analysis
36	Data Cleansing Extract Authors	Intermediate	Preparation,Data Analysis,Join,Transform
37	Parsing a Raw XML File	Intermediate	Parse,Preparation,Data Analysis,Transform
38	Data Blending for Batch Output	Basic	Preparation,Join,Data Preparation
39	Trouble Shooting a Broken Macro	Intermediate	Preparation,Join,Transform,Macros,Interface
40	Parsing a HTML File	Intermediate	Preparation,Join,Data Preparation,Transform
41	Analytics PayPeriodCalc	Basic	Parse,Preparation,Data Preparation,Transform
42	Inspire Europe '16 Grand Prix (L1)	Intermediate	Preparation,Data Analysis,Join,Transform
43	Inspire Europe '16 Grand Prix (L2)	Intermediate	Spatial Analysis,Spatial,Parse,Preparation,Data Analysis,Join
44	Inspire Europe '16 Grand Prix (L3)	Intermediate	Preparation,Predictive,Data Analysis,Transform,Predictive Analysis
45	Parsing Bureau of Labor Data	Difficult	Parse,Preparation,Data Analysis,Developer
46	Formatting a Date from an Integer	Basic	Preparation,Data Preparation
47	Vehicle Identification Number Test	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
48	Calculating Distribution Priority	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Transform
49	Reformatting Transactional Data	Basic	Preparation,Join,Data Preparation,Transform
50	Preparing Survey Data	Intermediate	Preparation,Data Analysis,Join,Transform
51	Spatial County Coverage	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Transform
52	Solving the Knapsack Problem	Difficult	Preparation,Data Analysis,Join,Transform,Macros,Interface
53	Parsing Report Formatted Data	Intermediate	Parse,Preparation,Data Analysis,Developer,Data Preparation,Transform,Macros
54	Data Prep Address Parsing	Basic	Parse,Preparation,Join,Data Preparation
55	2013 Alteryx Grand Prix (L1)	Intermediate	Preparation,Data Analysis,Join,Transform
56	Parsing and Counting Hashtags	Intermediate	Parse,Preparation,Data Analysis,Transform
57	Build a Valentine's Day App	Intermediate	Spatial,Preparation,Apps,Interface
58	An Odd String to Date Conversion	Basic	Parse,Preparation,Data Preparation
59	Is it an Anagram?	Intermediate	Parse,Data Analysis,Join,Transform
60	Fill in the Spatial Object	Intermediate	Spatial Analysis,Spatial,Transform
61	Save the Astronaut	Difficult	Parse,Preparation,Data Analysis,Developer,Join,Transform
62	Find the Duplicate Clicks	Intermediate	Preparation,Data Analysis
63	Data Preperation Using Pivot Tools	Intermediate	Preparation,Data Analysis,Developer
64	Catch Me If You Can	Intermediate	Preparation,Developer,Data Preparation
65	Fulfilling Inventory Orders	Basic	Preparation,Data Analysis,Join
66	My Wine Problem	Intermediate	Preparation,Transform,Macros,Interface
67	Calculate Spatial Angles	Intermediate	Spatial Analysis,Spatial,Preparation,Transform
68	Elapsed Classroom Times	Basic	Preparation,Data Analysis
69	Web Stock Data	Basic	Parse,Preparation,Data Preparation
70	Trade Area Drivetime Radii	Basic	Spatial Analysis,Spatial,Transform
71	Recreate SQL Joins in Alteryx	Intermediate	Join,Data Preparation
72	Compare Data Sets (Fields/Columns)	Intermediate	Preparation,Developer,Join,Data Preparation,Reporting
73	Plinko Probabilities	Difficult	Parse,Preparation,Data Analysis,Join,Transform
74	Build a Factorial Calculator	Basic	Preparation,Transform,Macros,Interface
75	Scrabble Word Finder	Difficult	Parse,Preparation,Data Analysis,Join,Data Preparation
76	Strava Export Parse and Report	Intermediate	Spatial Analysis,Spatial,Parse,Data Analysis,Data Preparation,Reporting
77	Extending Spatial Lines	Intermediate	Spatial,Preparation,Macros,Interface
78	Find the Best Housing Markets	Intermediate	Parse,Preparation,Data Analysis,Developer,Join,Data Preparation
79	Find the Closest Prime Number	Intermediate	Preparation,Join,Transform,Apps,Macros,Interface
80	Slowly Changing Dimensions	Intermediate	Preparation,Data Analysis,Join
81	Multi-Level Bill of Materials Problem	Intermediate	Preparation,Join,Macros,Interface
82	Are You in the Path of the Solar Eclipse?	Intermediate	Spatial Analysis,Spatial,Parse,Preparation,Developer,Join,Data Preparation
83	Pop-Tart and Beer Pairings	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation
84	Map Hurricane Harvey's Storm Evolution	Intermediate	Spatial Analysis,Spatial,Data Analysis,Join,Transform,Macros,Interface
85	How Did Tara Place in Competition?	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
86	Create a Macro that Generates Past Dates	Intermediate	Macros,Interface
87	Losing Daylight	Basic	Parse,Preparation,Data Analysis,Data Preparation
88	Counting Combinations	Basic	Preparation,Data Preparation,Transform
89	Analyzing Social Data	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform,Apps,Interface
90	Analyzing Social Data (Part 2)	Difficult	Reporting and Visualization,Data Analysis,Reporting
91	Getting into the Weeds	Difficult	Parse,Preparation,Data Analysis,Developer,Join,Data Preparation,Reporting,Apps,Interface
92	The Blob!	Basic	Preparation,Developer,Data Preparation,Reporting
93	Pumpkin Production	Basic	Parse,Preparation,Data Analysis,Developer,Join,Data Preparation,Transform
94	Have we reached Peak Pumpkin?	Difficult	Data Investigation,Parse,Preparation,Time Series,Macros,Predictive Analysis
95	Draw 1000 Apples in Under 60 Seconds	Difficult	Data Investigation,Spatial Analysis,Reporting and Visualization,Spatial,Parse,Data Analysis,Developer,Join,Reporting,Transform
96	Who Stole my Latte?	Intermediate	Parse,Preparation,Data Analysis,Developer,Join,Data Preparation,Reporting
97	SANTALYTICS 2017 - Part 1	Intermediate	Preparation,Developer,Join,Data Preparation,Reporting
98	SANTALYTICS 2017 - Part 2	Intermediate	Reporting and Visualization,Preparation,Data Analysis,Join,Reporting
99	SANTALYTICS 2017 - Part 3	Difficult	Parse,Preparation,Data Analysis,Join,Transform
100	Find Ned!	Difficult	Spatial Analysis,Spatial,Preparation,Data Analysis,Transform
101	The Search for Powder	Intermediate	Spatial Analysis,Spatial,Parse,Preparation,Data Analysis,Join,Transform,Macros,Interface
102	Tabulating Flu Data	Basic	Preparation,Developer,Data Preparation,Transform
103	Just another game?	Difficult	Data Investigation,Parse,Preparation,Predictive,Data Analysis,Developer,Join,Data Preparation,Predictive Analysis
104	Love's not the only thing in the air!	Basic	Reporting and Visualization,Parse,Preparation,Data Analysis,Join,Reporting,Transform
105	Think Like a CSE… Tools are missing!	Intermediate	Reporting and Visualization,Parse,Data Analysis,Developer,Reporting,Macros
106	How Long were the Lights On?	Basic	Preparation,Data Analysis,Transform
107	Plot Employment Rates by Gender in the US	Difficult	Reporting and Visualization,Preparation,Data Analysis,Reporting
108	HeLa Cell Multiplication	Intermediate	Preparation,Data Analysis,Join,Transform,Macros,Interface
109	Women in Government Around the World	Basic	Reporting and Visualization,Preparation,Data Analysis,Reporting,Transform
110	Think Like a CSE...Reduce the manual inputs!	Intermediate	Preparation,Data Analysis,Join,Data Preparation,Apps,Macros,Interface
111	Make a Weekly Challenge Dream Team!	Intermediate	Preparation,Join,Data Preparation,Transform
112	Organizing Survey Data	Intermediate	Preparation,Data Analysis,Developer,Data Preparation,Transform
113	Interpolating Spatial Grid Values	Difficult	Spatial Analysis,Spatial,Preparation,Join,Transform
114	Think Like a CSE...Remove the extra delimiter from the JSON output	Intermediate	Developer,Data Preparation,Transform
115	Let's get crafty!	Intermediate	Preparation,Join,Transform,Apps
116	A Symphony of Parsing Tools!	Difficult	Parse,Preparation,Data Analysis,Developer,Join,Transform
117	Credit/Debit Midpoints	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
118	Think Like a CSE - A not-so-wild-wildcard input!	Intermediate	Preparation,Data Preparation,Macros
119	Inspire Weekly Challenge	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform,Macros
120	Popular Baby Names	Basic	Parse,Preparation,Data Analysis,Developer,Join,Data Preparation,Transform
121	World Cup 2018!	Basic	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
122	Think Like a CSE...Ranking Data	Intermediate	Preparation,Data Preparation
123	When will Rabbits Rule the World?	Intermediate	Preparation,Data Analysis,Data Preparation,Transform,Macros
124	Air Transport Network Analysis	Difficult	Preparation,Predictive,Join,Data Preparation,Transform
125	US Grand Prix Lap 1 - Data Prep	Basic	Data Investigation,Preparation,Join,Data Preparation
126	Fill in the [Date] Gaps	Intermediate	Preparation,Data Analysis,Data Preparation,Transform
127	US Grand Prix Lap 2 - Employee Retention	Intermediate	Preparation,Predictive,Data Preparation
128	Settle the Score	Basic	Parse,Preparation,Data Analysis,Data Preparation,Transform
129	US Grand Prix Lap 3 - Where to Host an Event	Intermediate	Spatial Analysis,Spatial,Preparation,Predictive,Join,Data Preparation,Transform,Predictive Analysis
130	Is There an Echo in Here?	Intermediate	Parse,Data Analysis
131	Think Like a CSE... The R Error Message: cannot allocate vector of size...	Difficult	Preparation,Predictive,Data Preparation,Transform,Macros
132	When Will Community Hit 1,000,000 Posts?	Intermediate	Preparation,Predictive,Join,Data Preparation,Transform
133	US Grand Prix Prelims - NASA Location Analysis	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Data Preparation,Transform
134	US Grand Prix Prelims - Email Dates	Intermediate	Preparation,Predictive,Data Preparation
135	Locker Problem	Intermediate	Preparation,Data Preparation,Macros,Interface
136	Cleudo!	Difficult	Spatial Analysis,Spatial,Parse,Data Analysis,Join,Data Preparation,Transform
137	Find the Closest 'Dry' Point!	Basic	Preparation,Data Analysis,Join,Data Preparation,Transform
138	World Series Wins	Basic	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
139	Spooky API Connection	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
140	Prove the Birthday Paradox!	Intermediate	Preparation,Data Analysis,Data Preparation,Transform
141	Examination Data Simulation	Difficult	Preparation,Data Analysis,Join,Reporting,Transform,Macros
142	Life Certainties - Workflows, Death, and Taxes	Basic	Preparation,Developer,Join,Data Preparation,Transform
143	Developer Community Anniversary Edition	Difficult	Join,Data Preparation,Transform,Macros
144	Secret Santa Assignments (BAH HUMBUG!)	Basic	Preparation,Join,Data Preparation
145	SANTALYTICS 2018 - Part 1	Basic	Preparation,Data Analysis,Developer,Data Preparation,Transform,Macros
146	SANTALYTICS 2018 - Part 2	Intermediate	Data Analysis
147	EMEA Grand Prix Prelims - Time Series	Intermediate	Preparation,Predictive,Developer,Data Preparation,Predictive Analysis
148	Rotating Century Puzzle	Difficult	Preparation,Data Analysis,Join
149	Market Overlap	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Transform
150	Have the Stars Aligned?!	Intermediate	Data Analysis,Join,Reporting
151	Meta Parsing	Intermediate	Preparation,Data Analysis,Join,Transform
152	Finding Vehicle Counts	Intermediate	Calgary,Preparation,Join,Data Preparation
153	And the Oscar goes to...	Intermediate	Apps
154	Permute the Data	Difficult	Parse,Preparation,Data Analysis,Join,Data Preparation,Macros
155	March Cryptanalytics	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
156	What Position Should You Play?	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
157	An Expert Challenge	Difficult	Predictive,Data Preparation,Predictive Analysis
158	Personality Quiz	Intermediate	Preparation,Data Analysis,Join,Reporting,Apps,Interface
159	April ENcyptanalytics	Difficult	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
160	Diamonds R Forever	Difficult	Preparation,Predictive,Data Analysis,Join,Data Preparation,Transform
161	Triangles, Triangles, Triangles	Intermediate	Spatial Analysis,Preparation,Join,Data Preparation
162	Mondays....they're Marvel-ous!	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation
163	Caesar Cipher (on the way to Kryptos)	Intermediate	Parse,Preparation,Data Analysis,Data Preparation,Transform
164	Retail Therapy	Basic	Preparation,Data Analysis,Join,Data Preparation,Transform
165	KRYPTOS!!!	Difficult	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
166	I'm Gonna Be (500 Miles) - at Inspire	Intermediate	Spatial Analysis,Spatial,Preparation,Data Analysis,Join,Data Preparation,Reporting,Transform
167	Grand Prix 2019	Basic	Parse,Preparation,Join,Data Preparation,Transform
168	Dice Game - Born to Solve	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
169	Women's World Cup Wins	Basic	Preparation,Data Analysis,Join,Data Preparation,Transform
170	2019 Grand Prix US - Heat 1	Intermediate	Preparation,Predictive,Join,Data Preparation,Transform
171	2019 Grand Prix US - Heat 2	Intermediate	Data Analysis,Data Preparation,Transform
172	2019 Grand Prix US - Heat 3	Intermediate	Spatial Analysis,Spatial,Preparation,Data Analysis,Join,Transform,Macros
173	Tour de France - Crow Edition	Basic	Spatial Analysis,Spatial,Preparation,Join,Reporting,Transform
174	Appyhay Ondaymay!	Intermediate	Parse,Preparation,Join,Transform,Macros,Interface
175	Tire Size Calculator	Difficult	Parse,Preparation,Transform,Apps,Interface
176	Math Class Drill	Intermediate	Preparation,Data Analysis,Join,Transform
177	Ham Hamlet	Difficult	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
178	Chuck Like a Woodchuck	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
179	Calculating Order Status	Intermediate	Parse,Preparation,Data Analysis,Developer,Join
180	Thousand File Challenge	Difficult	Preparation,Join,Transform,Macros,Interface
181	Ingredients of an Old Southern	Intermediate	Parse,Preparation,Data Analysis,Developer,Join
182	Word Sleuthing	Basic	Parse,Preparation,Data Analysis,Join
183	Roman Numeral Math	Difficult	Parse,Preparation,Data Analysis,Developer,Join,Transform
184	Closest Pubs to Tobacco Dock	Intermediate	Spatial Analysis,Spatial,Preparation,Reporting,Transform
185	Amplify your Learning with Weekly Challenges!	Intermediate	Preparation,Data Analysis,Join,Transform
186	Drilling down into Data Analysis	Intermediate	Preparation,Data Analysis,Join,Transform
187	Generate Prime Numbers	Intermediate	Preparation,Data Analysis
188	Difficult, but not im-parse-able	Difficult	Parse,Preparation,Data Analysis,Join
189	Billboard Top 100	Basic	Preparation,Data Analysis,Join,Transform
190	Supply Chain Management Challenge	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
191	BINGO!	Basic,Intermediate,Difficult	Preparation,Join,Data Preparation,Reporting,Transform,Interface
192	Crane Leasing	Intermediate	Parse,Preparation,Data Analysis,Join,Data Preparation,Transform
193	Unofficial Holidays	Basic	Parse,Preparation,Data Preparation
194	SANTALYTICS 2019	Basic	Parse,Preparation,Data Analysis,Developer,Reporting
195	XML Parsing	Difficult	Parse,Preparation,Data Analysis
196	Determine Profit Margin	Intermediate	Parse,Preparation,Join,Data Preparation,Transform
197	Customer Density Reporting	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Reporting,Transform
198	Beverage Inventory	Intermediate	Preparation,Data Analysis,Join,Data Preparation,Transform
199	Let's all go to the movies!	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Data Preparation,Reporting,Transform
200	Sudoku Solver	Basic,Intermediate,Difficult	Parse,Preparation,Data Analysis,Join,Transform
201	Wage Ain't Nothin' but a Number	Intermediate	Preparation,Data Analysis,Join,Reporting
202	Love Poetry	Intermediate	Parse,Preparation,Transform,Apps,Interface
203	Everyone loves a toll booth	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
204	Updating Brazil	Intermediate	Spatial Analysis,Spatial,Preparation,Join,Transform
205	Taynalysis	Basic	Parse,Preparation,Join,Data Preparation,Transform
206	Hotel Reservations	Basic	Parse,Preparation,Data Preparation,Transform
207	Parsing Video Game Data	Intermediate	Parse,Preparation,Data Analysis,Developer,Join
208	COVIZ-19	Difficult	Parse,Preparation,Data Analysis,Join,Reporting
209	Parsing Insurance Claims	Difficult	Parse,Preparation,Data Analysis,Join,Transform
210	Better Late Than Never	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
211	Generating Email Addresses	Basic	Parse,Preparation,Data Analysis,Transform
212	Draft Masters	Basic	Preparation,Join,Data Preparation,Transform
213	Optimized Flower Arrangements	Intermediate	Predictive
214	US Military and High Points	Intermediate	Spatial,Parse,Preparation,Data Analysis,Transform
215	Gotta Catch 'em All!	Intermediate	Preparation,Transform,Apps,Interface
216	The Big Five	Intermediate	Preparation,Data Analysis,Join,Transform
217	A Fast Blast From The Past	Intermediate	Preparation,Data Analysis,Join,Transform
218	Car Sales Reporting	Intermediate	Reporting
219	Who Runs The World? Girls	Basic	Parse,Preparation,Data Preparation
220	Hedge Detection	Difficult	Spatial Analysis,Spatial,Preparation
221	Avocado Consumption	Intermediate	Preparation,Data Analysis,Transform
222	Where There's a Whale There's a Way	Basic	Preparation,Data Analysis,Join
223	Going Nuclear	Intermediate	Preparation,Data Analysis,Join,Transform
224	Mushroom for Improvement	Intermediate	Data Preparation
225	How Long Has It Been?	Intermediate	Apps,Interface
226	Flex-Ability	Basic	Spatial Analysis,Spatial,Transform
227	/comments/	Intermediate	Data Preparation
228	Know Your Boundaries	Difficult	Spatial Analysis,Spatial,Preparation,Join,Transform
229	Trend Analysis	Intermediate	Reporting
230	Take a Look, It's in a Book!	Intermediate	Parse,Preparation,Data Preparation,Reporting,Transform
231	What a Combo!	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
232	That's Sew 2020	Intermediate	Preparation,Data Analysis,Join,Transform
233	The Truth Is Out There	Intermediate	Spatial,Preparation,Data Analysis,Join,Reporting,Transform
234	Spell It Out For Me - Part 1	Intermediate	Parse,Preparation,Data Preparation,Transform
235	Spell It Out For Me - Part 2	Intermediate	Preparation,Join,Data Preparation,Transform
236	I Thought It Was Channel Surfing?	Intermediate	Spatial Analysis,Spatial,Preparation,Reporting,Transform
237	Wareki	Intermediate	Parse,Preparation,Join,Macros,Interface
238	Ideal Gases Don't Exist	Intermediate	Preparation,Transform,Apps,Interface
239	SEND + MORE = MONEY	Intermediate	Preparation,Data Analysis,Join,Transform
240	Every Vote Counts!	Intermediate	Preparation,Join,Transform,Macros
241	Friday the 13th	Intermediate	Preparation,Data Preparation,Transform
242	Meet Me Halfway	Intermediate	Spatial Analysis,Spatial,Parse,Preparation,Transform
243	Odd Man Out	Intermediate	Preparation,Developer,Join,Data Preparation,Transform
244	Cats and Dogs	Intermediate	Reporting
245	Zip It Real Good	Intermediate	Parse,Preparation,Join,Data Preparation
246	Rectangle Tangle	Intermediate	Spatial,Preparation,Join,Macros,Interface
247	Pairing Partners	Intermediate	Preparation,Join,Data Preparation,Transform
248	Holidates	Basic	Preparation,Data Analysis,Join
249	Highlights	Intermediate	Preparation,Data Analysis,Join,Reporting,Transform
250	Give Me A Sign	Difficult	Parse,Preparation,Join,Reporting,Transform,Apps,Interface
251	Lunacy	Difficult	Spatial Analysis,Spatial,Preparation,Join
252	Working Days Remaining	Intermediate	Parse,Preparation,Join,Macros,Interface
253	Delivery Dates	Basic	Preparation,Data Analysis,Join
254	DATA-DRIVEN COCKTAIL RECIPE - PART 1	Intermediate	Preparation,Predictive,Join,Transform,Predictive Analysis
255	DATA-DRIVEN COCKTAIL RECIPE - Part 2	Intermediate	Data Investigation,Preparation,Predictive,Transform,Predictive Analysis
256	Working Fore The Weekend	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
257	Palindromes	Intermediate	Preparation,Join,Transform,Macros,Interface
258	Relatively Old	Basic	Preparation,Data Preparation,Transform
259	Disenvowel	Intermediate	Parse,Preparation,Join,Data Preparation,Transform
260	Fuel Me Once...	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
261	Car Service Reminders	Intermediate	Preparation,Join,Data Preparation,Reporting,Transform
262	With-invoice	Difficult	Parse,Preparation,Join,Data Preparation,Transform
263	Supernatural 7-Sphere	Basic	Preparation,Join,Apps,Interface
264	Sliding Totals	Intermediate	Preparation,Data Analysis,Join,Transform
265	Keep In Touch	Difficult	Spatial,Parse,Preparation,Data Analysis,Join,Reporting,Transform
266	Mother's Day Bouquet	Intermediate	Spatial Analysis,Spatial,Macros,Interface
267	To Quote The Alphabet	Intermediate	Parse,Preparation,Data Analysis,Join,Transform,Macros
268	Definitely Not Made Up	Intermediate	Preparation,Join,Data Preparation,Transform
269	Population DenCities	Basic,Intermediate,Difficult	Spatial,Preparation,Data Analysis
270	Pony Permutations	Basic	Preparation,Data Analysis,Join,Transform
271	Dynamic Double Dip	Basic	Parse,Preparation,Join,Data Preparation,Transform
272	Configure It Out	Basic	Preparation,Join,Data Preparation,Reporting,Transform
273	Filling In The Blanks	Basic	Preparation,Join,Data Preparation,Transform
274	Concattributes	Basic	Parse,Preparation,Join,Data Preparation
275	Greatest Common Denominator	Difficult	Preparation,Data Analysis,Join,Transform
276	Getting Star-ted	Basic	Spatial Analysis,Spatial,Preparation,Join
277	2016 Summer Olympics	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
278	Women Athletes and The Olympics	Intermediate	Reporting and Visualization,Preparation,Data Analysis,Join,Reporting,Transform
279	How many Olympic Games per Continent?	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
280	Weather Permitting	Intermediate	Parse,Preparation,Data Analysis,Join,Transform
281	Holidays	Basic	Preparation,Data Preparation,Transform
282	Analyzing Earthquakes	Intermediate	Spatial Analysis,Reporting and Visualization,Spatial,Reporting
283	The Summer Paralympic Games 2020	Basic	Data Preparation
284	Division with Macros	Difficult	Macros
285	Around the world	Intermediate	Reporting and Visualization
286	Who turned the lights off?	Basic	Data Analysis
287	Find My Pet US	Basic	Spatial,Join,Data Preparation
288	Client's Rating Analysis	Basic	Data Analysis,Data Preparation
289	Prep a Shoe List	Intermediate	Data Preparation,Data Parsing
290	Unlock a World of Opportunities	Intermediate	Data Preparation,Data Parsing
291	A Winning Halloween Candy Basket	Basic	Data Preparation
292	It's about Pivoting, Prepping and Reporting!	Intermediate	Reporting and Visualization,Data Preparation
293	Top 5 Artists	Basic	Data Analysis,Reporting and Visualization,Data Preparation
294	Formula 1 Circuits	Intermediate	Spatial Analysis,Spatial,Preparation,Reporting
295	Thanksgiving Feast	Basic	Preparation,Data Preparation,Reporting,Transform
296	Breaking News - Headlines and Keywords	Basic	Data Analysis,Data Preparation
297	Rubik Cube	Intermediate	Preparation,Data Cleansing,Join,Data Preparation,Transform
298	Christmas Treasure Box	Basic	Preparation,Join,Data Preparation,Transform
299	Globetrotting Santa	Intermediate	Spatial Analysis,Spatial,Join,Reporting
300	Where is the party?	Basic	Data Analysis,Data Preparation
301	New Year's Resolutions	Intermediate	Preparation,Reporting and Visualization,Data Preparation,Reporting,Transform
302	International Bank of Awesome Data - Part I	Intermediate	Data Analysis,Data Preparation
303	International Bank of Awesome Data - Part II	Intermediate	Parse,Join,Macros,Interface
304	International Bank of Awesome Data - Part III	Intermediate	Reporting and Visualization,Data Preparation,Macros,Interface
305	International Bank of Awesome Data - Part IV	Basic	Reporting and Visualization,Data Preparation,Reporting
306	Corporate Superhero	Basic	Preparation,Reporting and Visualization,Data Cleansing,Join,Transform
307	Round-robin	Intermediate	Apps,Macros,Interface
308	Size it up	Basic	Preparation,Data Preparation
309	Movie Catalogue	Basic	Data Preparation,Reporting
310	Maintenance Schedule	Intermediate	Data Analysis,Data Preparation
311	Finding Whale Sharks	Basic	Spatial
312	Hours, Minutes and Seconds	Basic	Data Preparation
313	Base Converter	Difficult	Apps,Macros
314	Hot Real Estate Markets	Intermediate	Data Analysis,Data Preparation
315	The One Where Everyone Talked	Intermediate	Macros
316	Blowing in the Wind - Part 1	Basic	Data Preparation,Data Parsing
317	Blowing in the Wind - Part 2	Intermediate	Reporting and Visualization,Data Parsing
319	Sports Spots	Intermediate	Data Analysis,Data Preparation,Transform
320	Women Representation in Politics	Basic	Data Preparation,Reporting
321	Eurovision	Intermediate	Parse,Data Preparation
322	Good Ladies Heist	Intermediate	Data Preparation,Data Parsing
323	Analyze books Availabilities	Intermediate	Join,Data Preparation
324	Totals and Subtotals	Basic	Data Preparation,Reporting,Transform
325	How many hot dogs can you eat?	Intermediate	Data Analysis,Data Preparation
326	Totals and Subtotals Part 2	Basic	Data Preparation,Reporting,Transform
327	A place to stay	Intermediate	Parse,Data Preparation
328	Booking a Flight? Think Twice!	Basic	Join,Data Preparation,Transform
329	Near Earth Objects	Intermediate	Parse,Data Preparation,Transform
330	Check out the weather	Basic	Parse,Join,Data Preparation,Transform
331	Time for College!	Basic	Data Preparation,Transform

SeanAdams · ‎03-05-2017

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.

ErikaW · ‎03-05-2017

Thank you, @JoeM! So helpful!

Subratdas · ‎03-23-2017

This is a very helpful list. Thanks a lot for taking the effort.

Subrat

PaulRB · ‎04-07-2017

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?

JoeM · ‎04-07-2017

@PaulRB,

I have updated everything since challenge 61 so it can be compatible with your version of Designer. If you ever run into version issues with any workflows on Community - check this article that shows how to make workflows compatible with your version.

PaulRB · ‎04-10-2017

Thanks JoeM!

SeanAdams · ‎05-02-2017

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

JoeM · ‎05-02-2017

@SeanAdams

JoeM · ‎05-02-2017

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!

Weekly Challenge

IDEAS WANTED

Weekly Challenge Index & Welcome