We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Weekly Challenge Index & Welcome

JoeM
Alteryx Alumni (Retired)

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-12-05):

RankChallengerChallenges Completed
1 @AkimasaKajitani, @JamesCharnley, @Kenda, @LiuZhang, @PhilipMannering, @RolandSchubert, @TonyAndriani, @acarter881, @ggruccio, @patrick_digan347
2 @Watermark, @mmontgomery, @rmassambane346
3 @RWvanLeeuwen345
4 @Qiu344
5 @martinding333
6 @Jean-Balteryx332
7 @ARussell34, @binuacs330
8 @FrederikE329
9 @scoles0617327
10 @atcodedog05326

Top Solvers in the Last 30 Days:

RankChallengerChallenges Completed
1 @TungThanhHo104
2 @ZacharyRyanTIL78
3 @TimN76
4 @gerda71
5 @bobd, @martinding66
6 @JoachimCaron60
7 @Liusaidhowen53
8 @dougbaron50
9 @FinnCharlton45
10 @Kinga43

#Challenge NameLevel of DifficultyMain SubjectCertification Level
1Join to RangeIntermediateParse,Preparation,Join,Data Preparation,TransformCore
2Preparing Delimited DataBasicParse,Preparation,Data PreparationFoundation
3Running AveragesIntermediateParse,Preparation,Join,Data Preparation,TransformAdvanced
4Date ParsingDifficultParse,Preparation,Data AnalysisAdvanced
5HR Position Finder ApplicationIntermediatePreparation,Join,Transform,Apps,InterfaceAdvanced
6Spatial RouteIntermediateSpatial Analysis,Spatial,PreparationAdvanced
7Download Data and Parse JSONDifficultParse,Preparation,Data Analysis,Developer,TransformAdvanced
8Aggregate Consumer PurchasesBasicPreparation,Data Analysis,Join,TransformCore
9Analytics RankingBasicPreparation,Data AnalysisCore
10Date Time CalculationsIntermediatePreparation,Data AnalysisCore
11Identify Logical GroupsIntermediateParse,Data Analysis,Join,TransformAdvanced
12Creating an HR HierarchyDifficultPreparation,Join,Macros,InterfaceAdvanced
13HTML Table ParsingDifficultParse,Preparation,Data Analysis,TransformAdvanced
14Warehouse DistributionIntermediatePreparation,Join,Transform,MacrosAdvanced
15Warehouse Shipped MilesBasicSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
16Parsing Out the New-line CharacterBasicParse,Preparation,Data PreparationCore
17Month-over-Month Retention RateDifficultParse,Preparation,Join,Transform,Macros,InterfaceAdvanced
18Predicting Baseball WinsIntermediateData Investigation,Preparation,Predictive,Join,Transform,Predictive AnalysisExpert
19Excel Record LocatorBasicPreparation,Data Analysis,TransformAdvanced
20List ParsingDifficultParse,Preparation,Data Analysis,TransformAdvanced
21Date ReformattingBasicPreparation,Data Analysis,Data PreparationAdvanced
22Identify Values to AggregateIntermediateParse,Preparation,Data Preparation,TransformAdvanced
23Parsing CPG DataDifficultPreparation,Data Analysis,Join,TransformAdvanced
24ARIMA Time SeriesIntermediatePreparation,Predictive,Time Series,Join,Transform,Predictive AnalysisExpert
25Creating Merchant CombosIntermediatePreparation,Join,Data Preparation,TransformAdvanced
26Service Technician Travel DistanceIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
27Spatial Telco Coverage SmoothingIntermediateSpatial Analysis,Spatial,Preparation,TransformAdvanced
28Formatting Financial DataIntermediatePreparation,Data Analysis,Developer,Join,Data PreparationAdvanced
29Alteryx '16 Grand Prix (Race1, L1)IntermediatePreparation,Developer,Join,Data PreparationCore
30Alteryx '16 Grand Prix (Race 1, L2)BasicData Investigation,Preparation,Data Analysis,Join,TransformAdvanced
31Alteryx '16 Grand Prix (Race 2, L1)IntermediatePreparation,Developer,Join,Data PreparationCore
32Alteryx '16 Grand Prix (Race 2, L2)IntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
33Reshaping Nielsen DataIntermediatePreparation,Join,Data PreparationAdvanced
34Date-Time FormattingDifficultParse,Preparation,Macros,InterfaceAdvanced
35Data Cleansing PracticeBasicParse,Preparation,Data AnalysisCore
36Data Cleansing Extract AuthorsIntermediatePreparation,Data Analysis,Join,TransformAdvanced
37Parsing a Raw XML FileIntermediateParse,Preparation,Data Analysis,TransformAdvanced
38Data Blending for Batch OutputBasicPreparation,Join,Data PreparationCore
39Trouble Shooting a Broken MacroIntermediatePreparation,Join,Transform,Macros,InterfaceAdvanced
40Parsing a HTML FileIntermediatePreparation,Join,Data Preparation,TransformAdvanced
41Analytics PayPeriodCalcBasicParse,Preparation,Data Preparation,TransformAdvanced
42Inspire Europe '16 Grand Prix (L1)IntermediatePreparation,Data Analysis,Join,TransformCore
43Inspire Europe '16 Grand Prix (L2)IntermediateSpatial Analysis,Spatial,Parse,Preparation,Data Analysis,JoinAdvanced
44Inspire Europe '16 Grand Prix (L3)IntermediatePreparation,Predictive,Data Analysis,Transform,Predictive AnalysisPredictive
45Parsing Bureau of Labor DataDifficultParse,Preparation,Data Analysis,DeveloperAdvanced
46Formatting a Date from an IntegerBasicPreparation,Data PreparationCore
47Vehicle Identification Number TestIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformCore
48Calculating Distribution PriorityIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
49Reformatting Transactional DataBasicPreparation,Join,Data Preparation,TransformCore
50Preparing Survey DataIntermediatePreparation,Data Analysis,Join,TransformCore
51Spatial County CoverageIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
52Solving the Knapsack ProblemDifficultPreparation,Data Analysis,Join,Transform,Macros,InterfaceAdvanced
53Parsing Report Formatted DataIntermediateParse,Preparation,Data Analysis,Developer,Data Preparation,Transform,MacrosAdvanced
54Data Prep Address ParsingBasicParse,Preparation,Join,Data PreparationAdvanced
552013 Alteryx Grand Prix (L1)IntermediatePreparation,Data Analysis,Join,TransformAdvanced
56Parsing and Counting HashtagsIntermediateParse,Preparation,Data Analysis,TransformAdvanced
57Build a Valentine's Day AppIntermediateSpatial,Preparation,Apps,InterfaceAdvanced
58An Odd String to Date ConversionBasicParse,Preparation,Data PreparationCore
59Is it an Anagram?IntermediateParse,Data Analysis,Join,TransformAdvanced
60Fill in the Spatial ObjectIntermediateSpatial Analysis,Spatial,TransformAdvanced
61Save the AstronautDifficultParse,Preparation,Data Analysis,Developer,Join,TransformAdvanced
62Find the Duplicate ClicksIntermediatePreparation,Data AnalysisAdvanced
63Data Preperation Using Pivot ToolsIntermediatePreparation,Data Analysis,DeveloperAdvanced
64Catch Me If You CanIntermediatePreparation,Developer,Data PreparationAdvanced
65Fulfilling Inventory OrdersBasicPreparation,Data Analysis,JoinAdvanced
66My Wine ProblemIntermediatePreparation,Transform,Macros,InterfaceAdvanced
67Calculate Spatial AnglesIntermediateSpatial Analysis,Spatial,Preparation,TransformAdvanced
68Elapsed Classroom TimesBasicPreparation,Data AnalysisCore
69Web Stock DataBasicParse,Preparation,Data PreparationAdvanced
70Trade Area Drivetime RadiiBasicSpatial Analysis,Spatial,TransformAdvanced
71Recreate SQL Joins in AlteryxIntermediateJoin,Data PreparationAdvanced
72Compare Data Sets (Fields/Columns)IntermediatePreparation,Developer,Join,Data Preparation,ReportingAdvanced
73Plinko ProbabilitiesDifficultParse,Preparation,Data Analysis,Join,TransformExpert
74Build a Factorial CalculatorBasicPreparation,Transform,Macros,InterfaceAdvanced
75Scrabble Word FinderDifficultParse,Preparation,Data Analysis,Join,Data PreparationExpert
76Strava Export Parse and ReportIntermediateSpatial Analysis,Spatial,Parse,Data Analysis,Data Preparation,ReportingAdvanced
77Extending Spatial LinesIntermediateSpatial,Preparation,Macros,InterfaceAdvanced
78Find the Best Housing MarketsIntermediateParse,Preparation,Data Analysis,Developer,Join,Data PreparationAdvanced
79Find the Closest Prime NumberIntermediatePreparation,Join,Transform,Apps,Macros,InterfaceAdvanced
80Slowly Changing DimensionsIntermediatePreparation,Data Analysis,JoinAdvanced
81Multi-Level Bill of Materials ProblemIntermediatePreparation,Join,Macros,InterfaceAdvanced
82Are You in the Path of the Solar Eclipse?IntermediateSpatial Analysis,Spatial,Parse,Preparation,Developer,Join,Data PreparationAdvanced
83Pop-Tart and Beer PairingsIntermediateParse,Preparation,Data Analysis,Join,Data PreparationAdvanced
84Map Hurricane Harvey's Storm EvolutionIntermediateSpatial Analysis,Spatial,Data Analysis,Join,Transform,Macros,InterfaceAdvanced
85How Did Tara Place in Competition?IntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
86Create a Macro that Generates Past DatesIntermediateMacros,InterfaceAdvanced
87Losing DaylightBasicParse,Preparation,Data Analysis,Data PreparationAdvanced
88Counting CombinationsBasicPreparation,Data Preparation,TransformAdvanced
89Analyzing Social DataIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,Transform,Apps,InterfaceAdvanced
90Analyzing Social Data (Part 2)DifficultData Analysis,Reporting and Visualization,ReportingAdvanced
91Getting into the WeedsDifficultParse,Preparation,Data Analysis,Developer,Join,Data Preparation,Reporting,Apps,InterfaceAdvanced
92The Blob!BasicPreparation,Developer,Data Preparation,ReportingAdvanced
93Pumpkin ProductionBasicParse,Preparation,Data Analysis,Developer,Join,Data Preparation,TransformAdvanced
94Have we reached Peak Pumpkin?DifficultData Investigation,Parse,Preparation,Predictive,Macros,Predictive AnalysisExpert
95Draw 1000 Apples in Under 60 SecondsDifficultData Investigation,Spatial Analysis,Spatial,Parse,Data Analysis,Reporting and Visualization,Developer,Join,Reporting,TransformAdvanced
96Who Stole my Latte?IntermediateParse,Preparation,Data Analysis,Developer,Join,Data Preparation,ReportingAdvanced
97SANTALYTICS 2017 - Part 1IntermediatePreparation,Developer,Join,Data Preparation,ReportingAdvanced
98SANTALYTICS 2017 - Part 2IntermediatePreparation,Data Analysis,Reporting and Visualization,JoinAdvanced
99SANTALYTICS 2017 - Part 3DifficultParse,Preparation,Data Analysis,Join,TransformExpert
100Find Ned!DifficultSpatial Analysis,Spatial,Preparation,Data Analysis,TransformAdvanced
101The Search for PowderIntermediateSpatial Analysis,Spatial,Parse,Preparation,Data Analysis,Join,Transform,Macros,InterfaceAdvanced
102Tabulating Flu DataBasicPreparation,Developer,Data Preparation,TransformCore
103Just another game?DifficultData Investigation,Parse,Preparation,Predictive,Developer,Join,Data Preparation,Predictive AnalysisExpert
104Love's not the only thing in the air!BasicParse,Preparation,Data Analysis,Reporting and Visualization,Join,Reporting,TransformAdvanced
105Think Like a CSE… Tools are missing!IntermediateParse,Data Analysis,Reporting and Visualization,Developer,Reporting,MacrosAdvanced
106How Long were the Lights On?BasicPreparation,Data Analysis,TransformAdvanced
107Plot Employment Rates by Gender in the USDifficultPreparation,Data Analysis,Reporting and Visualization,ReportingAdvanced
108HeLa Cell MultiplicationIntermediatePreparation,Data Analysis,Join,Transform,Macros,InterfaceAdvanced
109Women in Government Around the WorldBasicPreparation,Data Analysis,Reporting and Visualization,Reporting,TransformAdvanced
110Think Like a CSE...Reduce the manual inputs!IntermediatePreparation,Data Analysis,Join,Data Preparation,Apps,Macros,InterfaceAdvanced
111Make a Weekly Challenge Dream Team!IntermediatePreparation,Join,Data Preparation,TransformAdvanced
112Organizing Survey DataIntermediatePreparation,Data Analysis,Developer,Data Preparation,TransformAdvanced
113Interpolating Spatial Grid ValuesDifficultSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
114Think Like a CSE...Remove the extra delimiter from the JSON outputIntermediateDeveloper,Data Preparation,TransformAdvanced
115Let's get crafty!IntermediatePreparation,Join,Transform,AppsAdvanced
116A Symphony of Parsing Tools!DifficultParse,Preparation,Data Analysis,Developer,Join,TransformExpert
117Credit/Debit MidpointsIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced
118Think Like a CSE - A not-so-wild-wildcard input!IntermediatePreparation,Data Preparation,MacrosAdvanced
119Inspire Weekly ChallengeIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,Transform,MacrosAdvanced
120Popular Baby NamesBasicParse,Preparation,Data Analysis,Developer,Join,Data Preparation,TransformAdvanced
121World Cup 2018!BasicParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
122Think Like a CSE...Ranking DataIntermediatePreparation,Data PreparationAdvanced
123When will Rabbits Rule the World?IntermediatePreparation,Data Analysis,Data Preparation,Transform,MacrosAdvanced
124Air Transport Network AnalysisDifficultPreparation,Predictive,Join,Data Preparation,Transform,Predictive AnalysisExpert
125US Grand Prix Lap 1 - Data PrepBasicData Investigation,Preparation,Join,Data PreparationAdvanced
126Fill in the [Date] GapsIntermediatePreparation,Data Analysis,Data Preparation,TransformAdvanced
127US Grand Prix Lap 2 - Employee RetentionIntermediatePreparation,PredictivePredictive
128Settle the ScoreBasicParse,Preparation,Data Analysis,Data Preparation,TransformCore
129US Grand Prix Lap 3 - Where to Host an EventIntermediateSpatial Analysis,Spatial,Preparation,Predictive,Join,Data Preparation,Transform,Predictive AnalysisAdvanced
130Is There an Echo in Here?IntermediateParse,Data AnalysisAdvanced
131Think Like a CSE... The R Error Message: cannot allocate vector of size...DifficultPreparation,Predictive,Transform,MacrosPredictive
132When Will Community Hit 1,000,000 Posts?IntermediatePreparation,Predictive,Join,TransformPredictive
133US Grand Prix Prelims - NASA Location AnalysisIntermediateSpatial Analysis,Spatial,Preparation,Join,Data Preparation,TransformAdvanced
134US Grand Prix Prelims - Email DatesIntermediatePreparation,PredictivePredictive
135Locker ProblemIntermediatePreparation,Data Preparation,Macros,InterfaceAdvanced
136Cleudo!DifficultSpatial Analysis,Spatial,Parse,Data Analysis,Join,Data Preparation,TransformAdvanced
137Find the Closest 'Dry' Point!BasicPreparation,Data Analysis,Join,Data Preparation,TransformAdvanced
138World Series WinsBasicParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
139Spooky API ConnectionIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
140Prove the Birthday Paradox!IntermediatePreparation,Data Analysis,Data Preparation,TransformAdvanced
141Examination Data SimulationDifficultPreparation,Data Analysis,Join,Reporting,Transform,MacrosAdvanced
142Life Certainties - Workflows, Death, and TaxesBasicPreparation,Developer,Join,Data Preparation,TransformAdvanced
143Developer Community Anniversary EditionDifficultPredictive,Join,Transform,MacrosExpert
144Secret Santa Assignments (BAH HUMBUG!)BasicPreparation,Join,Data PreparationCore
145SANTALYTICS 2018 - Part 1BasicPreparation,Data Analysis,Developer,Data Preparation,Transform,MacrosAdvanced
146SANTALYTICS 2018 - Part 2IntermediateData AnalysisAdvanced
147EMEA Grand Prix Prelims - Time SeriesIntermediatePreparation,Predictive,Developer,Predictive AnalysisPredictive
148Rotating Century PuzzleDifficultPreparation,Data Analysis,JoinAdvanced
149Market OverlapIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
150Have the Stars Aligned?!IntermediateData Analysis,Join,ReportingAdvanced
151Meta ParsingIntermediatePreparation,Data Analysis,Join,TransformAdvanced
152Finding Vehicle CountsIntermediateCalgary,Preparation,Join,Data PreparationAdvanced
153And the Oscar goes to...IntermediateAppsAdvanced
154Permute the DataDifficultParse,Preparation,Data Analysis,Join,Data Preparation,MacrosAdvanced
155March CryptanalyticsIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced
156What Position Should You Play?IntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
157An Expert ChallengeDifficultPredictive,Data Preparation,Predictive AnalysisExpert
158Personality QuizIntermediatePreparation,Data Analysis,Join,Reporting,Apps,InterfaceAdvanced
159April ENcyptanalyticsDifficultParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
160Diamonds R ForeverDifficultPreparation,Predictive,Join,Data Preparation,TransformPredictive
161Triangles, Triangles, TrianglesIntermediateSpatial Analysis,Preparation,Join,Data PreparationAdvanced
162Mondays....they're Marvel-ous!IntermediateParse,Preparation,Data Analysis,Join,Data PreparationCore
163Caesar Cipher (on the way to Kryptos)IntermediateParse,Preparation,Data Analysis,Data Preparation,TransformAdvanced
164Retail TherapyBasicPreparation,Data Analysis,Join,Data Preparation,TransformCore
165KRYPTOS!!!DifficultParse,Preparation,Data Analysis,Join,Data Preparation,TransformExpert
166I'm Gonna Be (500 Miles) - at InspireIntermediateSpatial Analysis,Spatial,Preparation,Data Analysis,Join,Data Preparation,Reporting,TransformAdvanced
167Grand Prix 2019BasicParse,Preparation,Join,Data Preparation,TransformCore
168Dice Game - Born to SolveIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
169Women's World Cup WinsBasicPreparation,Data Analysis,Join,Data Preparation,TransformFoundation
1702019 Grand Prix US - Heat 1IntermediatePreparation,Predictive,Join,TransformPredictive
1712019 Grand Prix US - Heat 2IntermediateData Analysis,Data Preparation,TransformAdvanced
1722019 Grand Prix US - Heat 3IntermediateSpatial Analysis,Spatial,Preparation,Data Analysis,Join,Transform,MacrosAdvanced
173Tour de France - Crow EditionBasicSpatial Analysis,Spatial,Preparation,Join,Reporting,TransformAdvanced
174Appyhay Ondaymay!IntermediateParse,Preparation,Join,Transform,Macros,InterfaceAdvanced
175Tire Size CalculatorDifficultParse,Preparation,Transform,Apps,InterfaceAdvanced
176Math Class DrillIntermediatePreparation,Data Analysis,Join,TransformAdvanced
177Ham HamletDifficultParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced
178Chuck Like a WoodchuckIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced
179Calculating Order StatusIntermediateParse,Preparation,Data Analysis,Developer,JoinAdvanced
180Thousand File ChallengeDifficultPreparation,Join,Transform,Macros,InterfaceAdvanced
181Ingredients of an Old SouthernIntermediateParse,Preparation,Data Analysis,Developer,JoinAdvanced
182Word SleuthingBasicParse,Preparation,Data Analysis,JoinCore
183Roman Numeral MathDifficultParse,Preparation,Data Analysis,Developer,Join,TransformAdvanced
184Closest Pubs to Tobacco DockIntermediateSpatial Analysis,Spatial,Preparation,Reporting,TransformAdvanced
185Amplify your Learning with Weekly Challenges!IntermediatePreparation,Data Analysis,Join,TransformAdvanced
186Drilling down into Data AnalysisIntermediatePreparation,Data Analysis,Join,TransformAdvanced
187Generate Prime NumbersIntermediatePreparation,Data AnalysisAdvanced
188Difficult, but not im-parse-ableDifficultParse,Preparation,Data Analysis,JoinAdvanced
189Billboard Top 100BasicPreparation,Data Analysis,Join,TransformCore
190Supply Chain Management ChallengeIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformCore
191BINGO!Basic,Intermediate,DifficultPreparation,Join,Data Preparation,Reporting,Transform,InterfaceAdvanced
192Crane LeasingIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformCore
193Unofficial HolidaysBasicParse,Preparation,Data PreparationCore
194SANTALYTICS 2019BasicParse,Preparation,Data Analysis,Developer,ReportingAdvanced
195XML ParsingDifficultParse,Preparation,Data AnalysisAdvanced
196Determine Profit MarginIntermediateParse,Preparation,Join,Data Preparation,TransformCore
197Customer Density ReportingIntermediateSpatial Analysis,Spatial,Preparation,Join,Reporting,TransformAdvanced
198Beverage InventoryIntermediatePreparation,Data Analysis,Join,Data Preparation,TransformCore
199Let's all go to the movies!IntermediateSpatial Analysis,Spatial,Preparation,Join,Data Preparation,Reporting,TransformAdvanced
200Sudoku SolverBasic,Intermediate,DifficultParse,Preparation,Data Analysis,Join,TransformAdvanced
201Wage Ain't Nothin' but a NumberIntermediatePreparation,Data Analysis,Join,ReportingAdvanced
202Love PoetryIntermediateParse,Preparation,Transform,Apps,InterfaceAdvanced
203Everyone loves a toll boothIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced
204Updating BrazilIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
205TaynalysisBasicParse,Preparation,Join,Data Preparation,TransformCore
206Hotel ReservationsBasicParse,Preparation,Data Preparation,TransformCore
207Parsing Video Game DataIntermediateParse,Preparation,Data Analysis,Developer,JoinAdvanced
208COVIZ-19DifficultParse,Preparation,Data Analysis,Join,ReportingAdvanced
209Parsing Insurance ClaimsDifficultParse,Preparation,Data Analysis,Join,TransformAdvanced
210Better Late Than NeverIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced
211Generating Email AddressesBasicParse,Preparation,Data Analysis,TransformAdvanced
212Draft MastersBasicPreparation,Join,Data Preparation,TransformAdvanced
213Optimized Flower ArrangementsIntermediatePredictivePredictive
214US Military and High PointsIntermediateSpatial,Parse,Preparation,Data Analysis,TransformAdvanced
215Gotta Catch 'em All!IntermediatePreparation,Transform,Apps,InterfaceAdvanced
216The Big FiveIntermediatePreparation,Data Analysis,Join,TransformAdvanced
217A Fast Blast From The PastIntermediatePreparation,Data Analysis,Join,TransformAdvanced
218Car Sales ReportingIntermediateReportingAdvanced
219Who Runs The World? GirlsBasicParse,Preparation,Data PreparationCore
220Hedge DetectionDifficultSpatial Analysis,Spatial,PreparationAdvanced
221Avocado ConsumptionIntermediatePreparation,Data Analysis,TransformCore
222Where There's a Whale There's a WayBasicPreparation,Data Analysis,JoinCore
223Going NuclearIntermediatePreparation,Data Analysis,Join,TransformAdvanced
224Mushroom for ImprovementIntermediateData PreparationCore
225How Long Has It Been?IntermediateApps,InterfaceAdvanced
226Flex-AbilityBasicSpatial Analysis,Spatial,TransformAdvanced
227/*comments*/IntermediateData PreparationCore
228Know Your BoundariesDifficultSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced
229Trend AnalysisIntermediateReportingAdvanced
230Take a Look, It's in a Book!IntermediateParse,Preparation,Data Preparation,Reporting,TransformAdvanced
231What a Combo!IntermediateParse,Preparation,Data Analysis,Join,TransformCore
232That's Sew 2020IntermediatePreparation,Data Analysis,Join,TransformCore
233The Truth Is Out ThereIntermediateSpatial,Preparation,Data Analysis,Join,Reporting,TransformAdvanced
234Spell It Out For Me - Part 1IntermediateParse,Preparation,Data Preparation,TransformCore
235Spell It Out For Me - Part 2IntermediatePreparation,Join,Data Preparation,TransformCore
236I Thought It Was Channel Surfing?IntermediateSpatial Analysis,Spatial,Preparation,Reporting,TransformAdvanced
237WarekiIntermediateParse,Preparation,Join,Macros,InterfaceAdvanced
238Ideal Gases Don't ExistIntermediatePreparation,Transform,Apps,InterfaceAdvanced
239SEND + MORE = MONEYIntermediatePreparation,Data Analysis,Join,TransformAdvanced
240Every Vote Counts!IntermediatePreparation,Join,Transform,MacrosAdvanced
241Friday the 13thIntermediatePreparation,Data Preparation,TransformAdvanced
242Meet Me HalfwayIntermediateSpatial Analysis,Spatial,Parse,Preparation,TransformAdvanced
243Odd Man OutIntermediatePreparation,Developer,Join,Data Preparation,TransformAdvanced
244Cats and DogsIntermediateReportingAdvanced
245Zip It Real GoodIntermediateParse,Preparation,Join,Data PreparationAdvanced
246Rectangle TangleIntermediateSpatial,Preparation,Join,Macros,InterfaceAdvanced
247Pairing PartnersIntermediatePreparation,Join,Data Preparation,TransformAdvanced
248HolidatesBasicPreparation,Data Analysis,JoinCore
249HighlightsIntermediatePreparation,Data Analysis,Join,Reporting,TransformAdvanced
250Give Me A SignDifficultParse,Preparation,Join,Reporting,Transform,Apps,InterfaceAdvanced
251LunacyDifficultSpatial Analysis,Spatial,Preparation,JoinAdvanced
252Working Days RemainingIntermediateParse,Preparation,Join,Macros,InterfaceAdvanced
253Delivery DatesBasicPreparation,Data Analysis,JoinCore
254DATA-DRIVEN COCKTAIL RECIPE - PART 1IntermediatePreparation,Predictive,Join,Transform,Predictive AnalysisPredictive
255DATA-DRIVEN COCKTAIL RECIPE - Part 2IntermediateData Investigation,Preparation,Predictive,Transform,Predictive AnalysisPredictive
256Working Fore The WeekendIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced
257PalindromesIntermediatePreparation,Join,Transform,Macros,InterfaceAdvanced
258Relatively OldBasicPreparation,Data Preparation,TransformCore
259DisenvowelIntermediateParse,Preparation,Join,Data Preparation,TransformCore
260Fuel Me Once...IntermediateParse,Preparation,Data Analysis,Join,TransformCore
261Car Service RemindersIntermediatePreparation,Join,Data Preparation,Reporting,TransformAdvanced
262With-invoiceDifficultParse,Preparation,Join,Data Preparation,TransformAdvanced
263Supernatural 7-SphereBasicPreparation,Join,Apps,InterfaceAdvanced
264Sliding TotalsIntermediatePreparation,Data Analysis,Join,TransformAdvanced
265Keep In TouchDifficultSpatial,Parse,Preparation,Data Analysis,Join,Reporting,TransformAdvanced
266Mother's Day BouquetIntermediateSpatial Analysis,Spatial,Macros,InterfaceAdvanced
267To Quote The AlphabetIntermediateParse,Preparation,Data Analysis,Join,Transform,MacrosAdvanced
268Definitely Not Made UpIntermediatePreparation,Join,Data Preparation,TransformCore
269Population DenCitiesBasic,Intermediate,DifficultSpatial,Preparation,Data AnalysisAdvanced
270Pony PermutationsBasicPreparation,Data Analysis,Join,TransformCore
271Dynamic Double DipBasicParse,Preparation,Join,Data Preparation,TransformCore
272Configure It OutBasicPreparation,Join,Data Preparation,Reporting,TransformAdvanced
273Filling In The BlanksBasicPreparation,Join,Data Preparation,TransformCore
274ConcattributesBasicParse,Preparation,Join,Data PreparationCore
275Greatest Common DenominatorDifficultPreparation,Data Analysis,Join,TransformAdvanced
276Getting Star-tedBasicSpatial Analysis,Spatial,Preparation,JoinAdvanced
2772016 Summer OlympicsIntermediateParse,Preparation,Data Analysis,Join,TransformCore
278Women Athletes and The OlympicsIntermediatePreparation,Data Analysis,Reporting and Visualization,Join,Reporting,TransformAdvanced
279How many Olympic Games per Continent?IntermediateParse,Preparation,Data Analysis,Join,TransformCore
280Weather PermittingIntermediateParse,Preparation,Data Analysis,Join,TransformCore
281HolidaysBasicPreparation,Data Preparation,TransformCore
282Analyzing EarthquakesIntermediateSpatial Analysis,Spatial,Reporting and Visualization,ReportingAdvanced
283The Summer Paralympic Games 2020BasicData PreparationCore
284Division with MacrosDifficultMacrosAdvanced
285Around the worldIntermediateReporting and VisualizationAdvanced
286Who turned the lights off?BasicData AnalysisFoundation
287Find My Pet USBasicSpatial,Join,Data PreparationAdvanced
288Client's Rating AnalysisBasicData Analysis,Data PreparationFoundation
289Prep a Shoe ListParse,Data PreparationAdvanced
290Unlock a World of OpportunitiesParse,Data PreparationAdvanced
291A Winning Halloween Candy BasketBasicData PreparationFoundation
292It's about Pivoting, Prepping and Reporting!IntermediateReporting and Visualization,Data PreparationAdvanced
293Top 5 ArtistsBasicData Analysis,Data PreparationAdvanced
294Formula 1 CircuitsIntermediateSpatial Analysis,Spatial,Preparation,ReportingAdvanced
295Thanksgiving FeastBasicPreparation,Data Preparation,Reporting,TransformAdvanced
296Breaking News - Headlines and KeywordsBasicData Analysis,Data PreparationCore
297Rubik CubeIntermediatePreparation,Data Cleansing,Join,Data PreparationAdvanced
298Christmas Treasure BoxBasicPreparation,Join,Data Preparation,TransformCore
299Globetrotting SantaIntermediateSpatial Analysis,Spatial,Join,ReportingAdvanced
300Where is the party?BasicData Analysis,Data PreparationFoundation
301New Year's ResolutionsIntermediatePreparation,Reporting and Visualization,Data Preparation,Reporting,TransformAdvanced
302International Bank of Awesome Data - Part IIntermediateData Analysis,Data PreparationAdvanced
303International Bank of Awesome Data - Part IIIntermediateJoin,Macros,InterfaceAdvanced
304International Bank of Awesome Data - Part IIIIntermediateReporting and Visualization,Data Preparation,Macros,InterfaceAdvanced
305International Bank of Awesome Data - Part IVBasicReporting and Visualization,Data Preparation,ReportingAdvanced
306Corporate SuperheroBasicPreparation,Reporting and Visualization,Data Cleansing,Join,TransformAdvanced
307Round-robinIntermediateApps,Macros,InterfaceAdvanced
308Size it upBasicPreparation,Data PreparationCore
309Movie CatalogueBasicData Preparation,ReportingAdvanced
310Maintenance ScheduleIntermediateData Analysis,Data PreparationAdvanced
311Finding Whale SharksBasicSpatialAdvanced
312Hours, Minutes and SecondsBasicData PreparationCore
313Base ConverterDifficultApps,MacrosAdvanced
314Hot Real Estate MarketsIntermediateData Analysis,Data PreparationAdvanced
315The One Where Everyone TalkedIntermediateMacrosAdvanced
316Blowing in the Wind - Part 1BasicParse,Data PreparationAdvanced
317Blowing in the Wind - Part 2IntermediateParse,Reporting and VisualizationAdvanced
318My first dogBasicData Preparation,ReportingAdvanced
319Sports SpotsIntermediateData Analysis,Data PreparationCore
320Women Representation in PoliticsBasicData Preparation,ReportingAdvanced
321EurovisionIntermediateParse,Data PreparationAdvanced
322Good Ladies HeistIntermediateParse,Data PreparationCore
323Analyze books AvailabilitiesIntermediateJoin,Data PreparationAdvanced
324Totals and SubtotalsBasicData Preparation,Reporting,TransformAdvanced
325How many hot dogs can you eat?IntermediateData Analysis,Data PreparationAdvanced
326Totals and Subtotals Part 2BasicData Preparation,TransformCore
327A place to stayIntermediateParse,Data PreparationAdvanced
328Booking a Flight? Think Twice!BasicJoin,Data Preparation,TransformAdvanced
329Near Earth ObjectsIntermediateParse,Data Preparation,TransformAdvanced
330Check out the weatherBasicParse,Join,Data Preparation,TransformCore
331Time for College!BasicData Preparation,TransformCore
332The more ice cream, the better!IntermediateParse,Join,Data Preparation,TransformAdvanced
333Remote or Not RemoteIntermediateData Analysis,Data PreparationAdvanced
334Literacy PracticeBasicData Preparation,TransformCore
335Movie DecisionsBasicJoin,Data Preparation,TransformCore
336Valuable Technical SkillsBasicJoin,Data Preparation,TransformCore
337Create a New List from an Existing ListBasicParse,Data PreparationFoundation
338Let's Summarize!IntermediateParse,Preparation,TransformCore
339Say Cheese Part 1BasicParse,Preparation,TransformCore
340Say Cheese (Part 2)BasicPreparation,TransformCore
341A Marathon In ParisBasicSpatial,Parse,Data PreparationAdvanced
342A Marathon in Paris (Part 2)IntermediateSpatial,Parse,Data Preparation,ReportingAdvanced
343Average App CostIntermediateParse,Preparation,TransformCore
344World Cup Sweepstakes (Part 1)IntermediateParse,Preparation,Join,TransformCore
345World Cup Sweepstakes (Part 2)IntermediateParse,Preparation,Join,ReportingAdvanced
346Map Messi and Ronaldo's Goals (Part 1)IntermediatePreparation,Join,Transform,Data ParsingCore
347Map Messi and Ronaldo's Goals (Part 2)IntermediateSpatial,Parse,Preparation,Reporting,TransformAdvanced
SeanAdams
17 - Castor
17 - Castor

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
Alteryx Alumni (Retired)

Thank you, @JoeM! So helpful!

 

 

Subratdas
5 - Atom

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

 

Subrat

PaulRB
8 - Asteroid

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
Alteryx Alumni (Retired)

@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
8 - Asteroid

Thanks JoeM!

SeanAdams
17 - Castor
17 - Castor

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
Alteryx Alumni (Retired)
JoeM
Alteryx Alumni (Retired)

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!