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 (2021-10-21):

RankChallengerChallenges Completed
1 @AkimasaKajitani, @Kenda, @PhilipMannering, @RolandSchubert, @TonyA, @patrick_digan, @rmassambane288
2 @mbogusz287
3 @AngelosPachis285
4 @dsmdavid284
5 @OllieClarke, @ggruccio283
6 @kelly_gilbert274
7 @RichoBsJ272
8 @Jean-Balteryx271
9 @JasonHu268
10 @hanykowska262

Top Solvers in the Last 30 Days:

RankChallengerChallenges Completed
1 @TimN34
2 @MichelleL32
3 @AndrewSu, @Anmol9729
4 @angelakong22
5 @MichaelPilotFreight19
6 @Joe_Lipski18
7 @jjrbondoc17
8 @EW16
9 @rmassambane15
10 @pfaigmani14

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