Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Weekly Challenge Index & Welcome

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

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 - so you can add one of these shiny badges to your collection:

Top Challengers (Updated on 2018-12-15):

Want to crack the top 10? Below are our top 10 Challengers in terms of most completed challenges!

ChallengerChallenges Completed

Challenge NumberChallenge NameLevel of DifficultyMain Subject
1Join to RangeIntermediateData Preparation
2Preparing Delimited DataBeginnerData Parsing
3Running AveragesIntermediateData Preparation
4Date ParsingAdvancedData Parsing
5HR Position Finder ApplicationIntermediateApps
6Spatial RouteIntermediateSpatial
7Download Data and Parse JSONAdvancedData Parsing
8Aggregate Consumer PurchasesBeginnerData Analysis
9Analytics RankingBeginnerData Analysis
10Date Time CalculationsIntermediateData Analysis
11Identify Logical GroupsIntermediateData Analysis
12Creating an HR HierarchyAdvancedMacros
13HTML Table ParsingAdvancedData Parsing
14Warehouse DistributionIntermediateMacros
15Warehouse Shipped MilesBeginnerSpatial
16Parsing Out the New-line CharacterBeginnerData Cleansing
17Month-over-Month Retention RateAdvancedMacros
18Predicting Baseball WinsIntermediatePredictive
19Excel Record LocatorBeginnerData Cleansing
20List ParsingAdvancedData Preparation
21Date ReformattingBeginnerData Cleansing
22Identify Values to AggregateIntermediateData Parsing
23Parsing CPG DataAdvancedData Parsing
24ARIMA Time SeriesIntermediatePredictive
25Creating Merchant CombosIntermediateData Analysis
26Service Technician Travel DistanceBeginnerSpatial
27Spatial Telco Coverage SmoothingIntermediateSpatial
28Formatting Morningstar DataIntermediateData Cleansing
29Alteryx '16 Grand Prix (Race1, L1)IntermediateData Preparation
30Alteryx '16 Grand Prix (Race 1, L2)BeginnerData Analysis
31Alteryx '16 Grand Prix (Race 2, L1)IntermediateData Preparation
32Alteryx '16 Grand Prix (Race 2, L2)IntermediateSpatial
33Reshaping Nielsen DataIntermediateData Preparation
34Date-Time FormattingAdvancedMacros
35Data Cleansing PracticeBeginnerData Cleansing
36Data Cleansing Extract AuthorsIntermediateData Parsing
37Parsing a Raw XML FileIntermediateData Parsing
38Data Blending for Batch OutputBeginnerData Preparation
39Trouble Shooting a Broken MacroIntermediateMacros
40Parsing a HTML FileIntermediateData Parsing
41Analytics PayPeriodCalcBeginnerData Analysis
42Inspire Europe '16 Grand Prix (L1)IntermediateData Analysis
43Inspire Europe '16 Grand Prix (L2)IntermediateData Analysis
44Inspire Europe '16 Grand Prix (L3)IntermediateData Analysis
45Parsing Bureau of Labor DataAdvancedData Parsing
46Formatting a Date from an IntegerBeginnerData Preparation
47Vehicle Identification Number TestIntermediateData Preparation
48Calculating Distribution PriorityIntermediateSpatial
49Reformatting Transactional DataBeginnerData Preparation
50Preparing Survey DataAdvancedData Analysis
51Spatial County CoverageIntermediateSpatial
52Solving the Knapsack ProblemAdvancedData Analysis
53Parsing Report Formatted DataIntermediateData Parsing
54Data Prep Address ParsingBeginnerData Parsing
552013 Alteryx Grand Prix (L1)IntermediateData Analysis
56Parsing and Counting HashtagsIntermediateData Analysis
57Build a Valentine's Day AppIntermediateApps
58An Odd String to Date ConversionBeginnerData Preparation
59Is it an Anagram?IntermediateData Analysis
60Fill in the Spatial ObjectIntermediateSpatial
61Save the AstronautAdvancedData Analysis
62Find the Duplicate ClicksIntermediateData Analysis
63Data Preperation Using Pivot ToolsIntermediateData Preparation
64Catch Me If You CanIntermediateData Preparation
65Fulfilling Inventory OrdersBeginnerData Analysis
66My Wine ProblemIntermediateMacros
67Calculate Spatial AnglesIntermediateSpatial
68Elapsed Classroom TimesBeginnerData Analysis
69Web Stock DataBeginnerData Parsing
70Trade Area Drivetime RadiiBeginnerSpatial
71Recreate SQL Joins in AlteryxIntermediateData Preparation
72Compare Data Sets (Fields/Columns)IntermediateData Preparation
73Plinko ProbabilitiesAdvancedData Analysis
74Build a Factorial CalculatorBeginnerMacros
75Scrabble Word FinderAdvancedData Preparation
76Strava Export Parse and ReportIntermediateData Parsing
77Extending Spatial LinesIntermediateSpatialMacros
78Find the Best Housing MarketsIntermediateData Parsing
79Find the Closest Prime NumberIntermediateApps
80Slowly Changing DimensionsIntermediateData Preparation
81Multi-Level Bill of Materials Probl...IntermediateData Analysis
82Are You in the Path of the Solar Ec...IntermediateSpatial
83Pop-Tart and Beer PairingsIntermediateData Preparation
84Map Hurricane Harvey's Storm Evol...IntermediateSpatial
85How Did Tara Place in Competition?IntermediateData Analysis
86Create a Macro that Generates Past ...AdvancedMacros
87Losing DaylightBeginnerData Analysis
88Counting CombinationsBeginnerData Analysis
89Analyzing Social DataBeginnerData Analysis
90Analyzing Social Data (Part 2)IntermediateData Analysis
91Getting into the WeedsAdvancedApps
92The Blob!BeginnerData Parsing
93Pumpkin ProductionBeginnerData Analysis
94Have we reached Peak Pumpkin?AdvancedPredictive
95Draw 1000 Apples in Under 60 Second...AdvancedSpatial
96Who Stole my Latte?IntermediateData Preparation
97SANTALYTICS 2017 - Part 1IntermediateData Preparation
98SANTALYTICS 2017 - Part 2IntermediateData Analysis
99SANTALYTICS 2017 - Part 3AdvancedData Analysis
100Find Ned!AdvancedSpatial
101The Search for PowderIntermediateData Analysis
102Tabulating Flu DataBeginnerData Preparation
103Just another game?AdvancedPredictive
104Love's not the only thing in the a...BeginnerData Analysis
105Think Like a CSE… Tools are missin...IntermediateMacros
106How Long were the Lights On?BeginnerData Analysis
107Plot Employment Rates by Gender in...AdvancedData Analysis
108HeLa Cell MultiplicationIntermediateData Analysis
109Women in Government Around the Wor...IntermediateData Preparation
110Think Like a CSE...Reduce the man...IntermediateMacrosApps
111Make a Weekly Challenge Dream Team...AdvancedData Analysis
112Organizing Survey DataIntermediateData Preparation
113Interpolating Spatial Grid ValuesAdvancedSpatial
114Think Like a CSE...Remove the extr...IntermediateData Preparation
115Let's get crafty!IntermediateApps
116A Symphony of Parsing Tools!AdvancedData Parsing
117Credit/Debit MidpointsIntermediateData Analysis
118Think Like a CSE - A not-so-wild-w...IntermediateData Preparation
119Inspire Weekly ChallengeIntermediateData Analysis
120Popular Baby NamesBeginnerData Analysis
121World Cup 2018!BeginnerData Cleansing
122Think Like a CSE...Ranking DataIntermediateData Analysis
123When will Rabbits Rule the World?IntermediateData Analysis
124Air Transport Network AnalysisAdvancedPredictive
125US Grand Prix Lap 1 - Data PrepBeginnerData Preparation
126Fill in the [Date] GapsIntermediateData Preparation
127US Grand Prix Lap 2 - Employee Ret...IntermediatePredictive
128Settle the ScoreBeginnerData Analysis
129US Grand Prix Lap 3 - Where to Hos...IntermediateSpatial
130Is There an Echo in Here?IntermediateData Parsing
131Think Like a CSE... The R Error Me...AdvancedPredictive
132When Will Community Hit 1,000,000 ...IntermediatePredictive
133US Grand Prix Prelims - NASA Locat...IntermediateSpatial
134US Grand Prix Prelims - Email Date...IntermediateData Cleansing
135Locker ProblemIntermediateMacros
136Cleudo!IntermediateAdvancedData ParsingSpatialData Analysis
137Find the Closest 'Dry' Point!BeginnerSpatial
138World Series WinsBeginnerData Analysis
139Spooky API ConnectionIntermediateData Analysis
140Prove the Birthday Paradox!IntermediateData Analysis
141Examination Data SimulationAdvancedData Analysis
142Life Certainties - Workflows, Deat...BeginnerData Preparation
143Developer Community Anniversary Ed...AdvancedMacros
144Secret Santa Assignments (BAH HUMB...BeginnerData Analysis
145SANTALYTICS 2018 - Part 1BeginnerData Analysis

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.

Alteryx Alumni (Retired)

Thank you, @JoeM! So helpful!



Alteryx Partner

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




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?

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager


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.


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




Sr. Learning Strategy Manager
Sr. Learning Strategy Manager
Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

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!