Welcome to the Weekly Challenges! 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) #Challenge NameLevel of DifficultyMain SubjectCertification Level1Join to RangeIntermediateParse,Preparation,Join,Data Preparation,TransformCore2Preparing Delimited DataBasicParse,Preparation,Data PreparationFoundation3Running AveragesIntermediateParse,Preparation,Join,Data Preparation,TransformAdvanced4Date ParsingDifficultParse,Preparation,Data AnalysisAdvanced5HR Position Finder ApplicationIntermediatePreparation,Join,Transform,Apps,InterfaceAdvanced6Spatial RouteIntermediateSpatial Analysis,Spatial,PreparationAdvanced7Download Data and Parse JSONDifficultParse,Preparation,Data Analysis,Developer,TransformAdvanced8Aggregate Consumer PurchasesBasicPreparation,Data Analysis,Join,TransformCore9Analytics RankingBasicPreparation,Data AnalysisCore10Date Time CalculationsIntermediatePreparation,Data AnalysisCore11Identify Logical GroupsIntermediateParse,Data Analysis,Join,TransformAdvanced12Creating an HR HierarchyDifficultPreparation,Join,Macros,InterfaceAdvanced13HTML Table ParsingDifficultParse,Preparation,Data Analysis,TransformAdvanced14Warehouse DistributionIntermediatePreparation,Join,Transform,MacrosAdvanced15Warehouse Shipped MilesBasicSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced16Parsing Out the New-line CharacterBasicParse,Preparation,Data PreparationCore17Month-over-Month Retention RateDifficultParse,Preparation,Join,Transform,Macros,InterfaceAdvanced18Predicting Baseball WinsIntermediateData Investigation,Preparation,Predictive,Join,Transform,Predictive AnalysisExpert19Excel Record LocatorBasicPreparation,Data Analysis,TransformCore20List ParsingDifficultParse,Preparation,Data Analysis,TransformAdvanced21Date ReformattingBasicPreparation,Data Analysis,Data PreparationAdvanced22Identify Values to AggregateIntermediateParse,Preparation,Data Preparation,TransformAdvanced23Parsing CPG DataDifficultPreparation,Data Analysis,Join,TransformAdvanced24ARIMA Time SeriesIntermediatePreparation,Predictive,Time Series,Join,Transform,Predictive AnalysisExpert25Creating Merchant CombosIntermediatePreparation,Join,Data Preparation,TransformAdvanced26Service Technician Travel DistanceIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced27Spatial Telco Coverage SmoothingIntermediateSpatial Analysis,Spatial,Preparation,TransformAdvanced28Formatting Financial DataIntermediatePreparation,Data Analysis,Developer,Join,Data PreparationAdvanced29Alteryx '16 Grand Prix (Race1, L1)IntermediatePreparation,Developer,Join,Data PreparationCore30Alteryx '16 Grand Prix (Race 1, L2)BasicData Investigation,Preparation,Data Analysis,Join,TransformAdvanced31Alteryx '16 Grand Prix (Race 2, L1)IntermediatePreparation,Developer,Join,Data PreparationCore32Alteryx '16 Grand Prix (Race 2, L2)IntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced33Reshaping Nielsen DataIntermediatePreparation,Join,Data PreparationAdvanced34Date-Time FormattingDifficultParse,Preparation,Macros,InterfaceAdvanced35Data Cleansing PracticeBasicParse,Preparation,Data AnalysisCore36Data Cleansing Extract AuthorsIntermediatePreparation,Data Analysis,Join,TransformAdvanced37Parsing a Raw XML FileIntermediateParse,Preparation,Data Analysis,TransformAdvanced38Data Blending for Batch OutputBasicPreparation,Join,Data PreparationCore39Trouble Shooting a Broken MacroIntermediatePreparation,Join,Transform,Macros,InterfaceAdvanced40Parsing a HTML FileIntermediatePreparation,Join,Data Preparation,TransformAdvanced41Analytics PayPeriodCalcBasicParse,Preparation,Data Preparation,TransformAdvanced42Inspire Europe '16 Grand Prix (L1)IntermediatePreparation,Data Analysis,Join,TransformCore43Inspire Europe '16 Grand Prix (L2)IntermediateSpatial Analysis,Spatial,Parse,Preparation,Data Analysis,JoinAdvanced44Inspire Europe '16 Grand Prix (L3)IntermediatePreparation,Predictive,Data Analysis,Transform,Predictive AnalysisPredictive45Parsing Bureau of Labor DataDifficultParse,Preparation,Data Analysis,DeveloperAdvanced46Formatting a Date from an IntegerBasicPreparation,Data PreparationCore47Vehicle Identification Number TestIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformCore48Calculating Distribution PriorityIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced49Reformatting Transactional DataBasicPreparation,Join,Data Preparation,TransformCore50Preparing Survey DataIntermediatePreparation,Data Analysis,Join,TransformCore51Spatial County CoverageIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced52Solving the Knapsack ProblemDifficultPreparation,Data Analysis,Join,Transform,Macros,InterfaceAdvanced53Parsing Report Formatted DataIntermediateParse,Preparation,Data Analysis,Developer,Data Preparation,Transform,MacrosAdvanced54Data Prep Address ParsingBasicParse,Preparation,Join,Data PreparationAdvanced552013 Alteryx Grand Prix (L1)IntermediatePreparation,Data Analysis,Join,TransformAdvanced56Parsing and Counting HashtagsIntermediateParse,Preparation,Data Analysis,TransformAdvanced57Build a Valentine's Day AppIntermediateSpatial,Preparation,Apps,InterfaceAdvanced58An Odd String to Date ConversionBasicParse,Preparation,Data PreparationCore59Is it an Anagram?IntermediateParse,Data Analysis,Join,TransformAdvanced60Fill in the Spatial ObjectIntermediateSpatial Analysis,Spatial,TransformAdvanced61Save the AstronautDifficultParse,Preparation,Data Analysis,Developer,Join,TransformAdvanced62Find the Duplicate ClicksIntermediatePreparation,Data AnalysisAdvanced63Data Preperation Using Pivot ToolsIntermediatePreparation,Data Analysis,DeveloperAdvanced64Catch Me If You CanIntermediatePreparation,Developer,Data PreparationAdvanced65Fulfilling Inventory OrdersBasicPreparation,Data Analysis,JoinAdvanced66My Wine ProblemIntermediatePreparation,Transform,Macros,InterfaceAdvanced67Calculate Spatial AnglesIntermediateSpatial Analysis,Spatial,Preparation,TransformAdvanced68Elapsed Classroom TimesBasicPreparation,Data AnalysisCore69Web Stock DataBasicParse,Preparation,Data PreparationAdvanced70Trade Area Drivetime RadiiBasicSpatial Analysis,Spatial,TransformAdvanced71Recreate SQL Joins in AlteryxIntermediateJoin,Data PreparationAdvanced72Compare Data Sets (Fields/Columns)IntermediatePreparation,Developer,Join,Data Preparation,ReportingAdvanced73Plinko ProbabilitiesDifficultParse,Preparation,Data Analysis,Join,TransformExpert74Build a Factorial CalculatorBasicPreparation,Transform,Macros,InterfaceAdvanced75Scrabble Word FinderDifficultParse,Preparation,Data Analysis,Join,Data PreparationExpert76Strava Export Parse and ReportIntermediateSpatial Analysis,Spatial,Parse,Data Analysis,Data Preparation,ReportingAdvanced77Extending Spatial LinesIntermediateSpatial,Preparation,Macros,InterfaceAdvanced78Find the Best Housing MarketsIntermediateParse,Preparation,Data Analysis,Developer,Join,Data PreparationAdvanced79Find the Closest Prime NumberIntermediatePreparation,Join,Transform,Apps,Macros,InterfaceAdvanced80Slowly Changing DimensionsIntermediatePreparation,Data Analysis,JoinAdvanced81Multi-Level Bill of Materials ProblemIntermediatePreparation,Join,Macros,InterfaceAdvanced82Are You in the Path of the Solar Eclipse?IntermediateSpatial Analysis,Spatial,Parse,Preparation,Developer,Join,Data PreparationAdvanced83Pop-Tart and Beer PairingsIntermediateParse,Preparation,Data Analysis,Join,Data PreparationAdvanced84Map Hurricane Harvey's Storm EvolutionIntermediateSpatial Analysis,Spatial,Data Analysis,Join,Transform,Macros,InterfaceAdvanced85How Did Tara Place in Competition?IntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced86Create a Macro that Generates Past DatesIntermediateMacros,InterfaceAdvanced87Losing DaylightBasicParse,Preparation,Data Analysis,Data PreparationAdvanced88Counting CombinationsBasicPreparation,Data Preparation,TransformAdvanced89Analyzing Social DataIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,Transform,Apps,InterfaceAdvanced90Analyzing Social Data (Part 2)DifficultData Analysis,Reporting and Visualization,ReportingAdvanced91Getting into the WeedsDifficultParse,Preparation,Data Analysis,Developer,Join,Data Preparation,Reporting,Apps,InterfaceAdvanced92The Blob!BasicPreparation,Developer,Data Preparation,ReportingAdvanced93Pumpkin ProductionBasicParse,Preparation,Data Analysis,Developer,Join,Data Preparation,TransformAdvanced94Have we reached Peak Pumpkin?DifficultData Investigation,Parse,Preparation,Predictive,Macros,Predictive AnalysisExpert95Draw 1000 Apples in Under 60 SecondsDifficultData Investigation,Spatial Analysis,Spatial,Parse,Data Analysis,Reporting and Visualization,Developer,Join,Reporting,TransformAdvanced96Who Stole my Latte?IntermediateParse,Preparation,Data Analysis,Developer,Join,Data Preparation,ReportingAdvanced97SANTALYTICS 2017 - Part 1IntermediatePreparation,Developer,Join,Data Preparation,ReportingAdvanced98SANTALYTICS 2017 - Part 2IntermediatePreparation,Data Analysis,Reporting and Visualization,JoinAdvanced99SANTALYTICS 2017 - Part 3DifficultParse,Preparation,Data Analysis,Join,TransformExpert100Find Ned!DifficultSpatial Analysis,Spatial,Preparation,Data Analysis,TransformAdvanced101The Search for PowderIntermediateSpatial Analysis,Spatial,Parse,Preparation,Data Analysis,Join,Transform,Macros,InterfaceAdvanced102Tabulating Flu DataBasicPreparation,Developer,Data Preparation,TransformCore103Just another game?DifficultData Investigation,Parse,Preparation,Predictive,Developer,Join,Data Preparation,Predictive AnalysisExpert104Love's not the only thing in the air!BasicParse,Preparation,Data Analysis,Reporting and Visualization,Join,Reporting,TransformAdvanced105Think Like a CSE… Tools are missing!IntermediateParse,Data Analysis,Reporting and Visualization,Developer,Reporting,MacrosAdvanced106How Long were the Lights On?BasicPreparation,Data Analysis,TransformAdvanced107Plot Employment Rates by Gender in the USDifficultPreparation,Data Analysis,Reporting and Visualization,ReportingAdvanced108HeLa Cell MultiplicationIntermediatePreparation,Data Analysis,Join,Transform,Macros,InterfaceAdvanced109Women in Government Around the WorldBasicPreparation,Data Analysis,Reporting and Visualization,Reporting,TransformAdvanced110Think Like a CSE...Reduce the manual inputs!IntermediatePreparation,Data Analysis,Join,Data Preparation,Apps,Macros,InterfaceAdvanced111Make a Weekly Challenge Dream Team!IntermediatePreparation,Join,Data Preparation,TransformAdvanced112Organizing Survey DataIntermediatePreparation,Data Analysis,Developer,Data Preparation,TransformAdvanced113Interpolating Spatial Grid ValuesDifficultSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced114Think Like a CSE...Remove the extra delimiter from the JSON outputIntermediateDeveloper,Data Preparation,TransformAdvanced115Let's get crafty!IntermediatePreparation,Join,Transform,AppsAdvanced116A Symphony of Parsing Tools!DifficultParse,Preparation,Data Analysis,Developer,Join,TransformExpert117Credit/Debit MidpointsIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced118Think Like a CSE - A not-so-wild-wildcard input!IntermediatePreparation,Data Preparation,MacrosAdvanced119Inspire Weekly ChallengeIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,Transform,MacrosAdvanced120Popular Baby NamesBasicParse,Preparation,Data Analysis,Developer,Join,Data Preparation,TransformAdvanced121World Cup 2018!BasicParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced122Think Like a CSE...Ranking DataIntermediatePreparation,Data PreparationAdvanced123When will Rabbits Rule the World?IntermediatePreparation,Data Analysis,Data Preparation,Transform,MacrosAdvanced124Air Transport Network AnalysisDifficultPreparation,Predictive,Join,Data Preparation,Transform,Predictive AnalysisExpert125US Grand Prix Lap 1 - Data PrepBasicData Investigation,Preparation,Join,Data PreparationAdvanced126Fill in the [Date] GapsIntermediatePreparation,Data Analysis,Data Preparation,TransformAdvanced127US Grand Prix Lap 2 - Employee RetentionIntermediatePreparation,PredictivePredictive128Settle the ScoreBasicParse,Preparation,Data Analysis,Data Preparation,TransformCore129US Grand Prix Lap 3 - Where to Host an EventIntermediateSpatial Analysis,Spatial,Preparation,Predictive,Join,Data Preparation,Transform,Predictive AnalysisAdvanced130Is There an Echo in Here?IntermediateParse,Data AnalysisAdvanced131Think Like a CSE... The R Error Message: cannot allocate vector of size...DifficultPreparation,Predictive,Transform,MacrosPredictive132When Will Community Hit 1,000,000 Posts?IntermediatePreparation,Predictive,Join,TransformPredictive133US Grand Prix Prelims - NASA Location AnalysisIntermediateSpatial Analysis,Spatial,Preparation,Join,Data Preparation,TransformAdvanced134US Grand Prix Prelims - Email DatesIntermediatePreparation,PredictivePredictive135Locker ProblemIntermediatePreparation,Data Preparation,Macros,InterfaceAdvanced136Cleudo!DifficultSpatial Analysis,Spatial,Parse,Data Analysis,Join,Data Preparation,TransformAdvanced137Find the Closest 'Dry' Point!BasicPreparation,Data Analysis,Join,Data Preparation,TransformAdvanced138World Series WinsBasicParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced139Spooky API ConnectionIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced140Prove the Birthday Paradox!IntermediatePreparation,Data Analysis,Data Preparation,TransformAdvanced141Examination Data SimulationDifficultPreparation,Data Analysis,Join,Reporting,Transform,MacrosAdvanced142Life Certainties - Workflows, Death, and TaxesBasicPreparation,Developer,Join,Data Preparation,TransformAdvanced143Developer Community Anniversary EditionDifficultPredictive,Join,Transform,MacrosExpert144Secret Santa Assignments (BAH HUMBUG!)BasicPreparation,Join,Data PreparationCore145SANTALYTICS 2018 - Part 1BasicPreparation,Data Analysis,Developer,Data Preparation,Transform,MacrosAdvanced146SANTALYTICS 2018 - Part 2IntermediateData AnalysisAdvanced147EMEA Grand Prix Prelims - Time SeriesIntermediatePreparation,Predictive,Developer,Predictive AnalysisPredictive148Rotating Century PuzzleDifficultPreparation,Data Analysis,JoinAdvanced149Market OverlapIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced150Have the Stars Aligned?!IntermediateData Analysis,Join,ReportingAdvanced151Meta ParsingIntermediatePreparation,Data Analysis,Join,TransformAdvanced152Finding Vehicle CountsIntermediateCalgary,Preparation,Join,Data PreparationAdvanced153And the Oscar goes to...IntermediateAppsAdvanced154Permute the DataDifficultParse,Preparation,Data Analysis,Join,Data Preparation,MacrosAdvanced155March CryptanalyticsIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced156What Position Should You Play?IntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced157An Expert ChallengeDifficultPredictive,Data Preparation,Predictive AnalysisExpert158Personality QuizIntermediatePreparation,Data Analysis,Join,Reporting,Apps,InterfaceAdvanced159April ENcyptanalyticsDifficultParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced160Diamonds R ForeverDifficultPreparation,Predictive,Join,Data Preparation,TransformPredictive161Triangles, Triangles, TrianglesIntermediateSpatial Analysis,Preparation,Join,Data PreparationAdvanced162Mondays....they're Marvel-ous!IntermediateParse,Preparation,Data Analysis,Join,Data PreparationCore163Caesar Cipher (on the way to Kryptos)IntermediateParse,Preparation,Data Analysis,Data Preparation,TransformAdvanced164Retail TherapyBasicPreparation,Data Analysis,Join,Data Preparation,TransformCore165KRYPTOS!!!DifficultParse,Preparation,Data Analysis,Join,Data Preparation,TransformExpert166I'm Gonna Be (500 Miles) - at InspireIntermediateSpatial Analysis,Spatial,Preparation,Data Analysis,Join,Data Preparation,Reporting,TransformAdvanced167Grand Prix 2019BasicParse,Preparation,Join,Data Preparation,TransformCore168Dice Game - Born to SolveIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced169Women's World Cup WinsBasicPreparation,Data Analysis,Join,Data Preparation,TransformFoundation1702019 Grand Prix US - Heat 1IntermediatePreparation,Predictive,Join,TransformPredictive1712019 Grand Prix US - Heat 2IntermediateData Analysis,Data Preparation,TransformAdvanced1722019 Grand Prix US - Heat 3IntermediateSpatial Analysis,Spatial,Preparation,Data Analysis,Join,Transform,MacrosAdvanced173Tour de France - Crow EditionBasicSpatial Analysis,Spatial,Preparation,Join,Reporting,TransformAdvanced174Appyhay Ondaymay!IntermediateParse,Preparation,Join,Transform,Macros,InterfaceAdvanced175Tire Size CalculatorDifficultParse,Preparation,Transform,Apps,InterfaceAdvanced176Math Class DrillIntermediatePreparation,Data Analysis,Join,TransformAdvanced177Ham HamletDifficultParse,Preparation,Data Analysis,Join,Data Preparation,TransformAdvanced178Chuck Like a WoodchuckIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced179Calculating Order StatusIntermediateParse,Preparation,Data Analysis,Developer,JoinAdvanced180Thousand File ChallengeDifficultPreparation,Join,Transform,Macros,InterfaceAdvanced181Ingredients of an Old SouthernIntermediateParse,Preparation,Data Analysis,Developer,JoinAdvanced182Word SleuthingBasicParse,Preparation,Data Analysis,JoinCore183Roman Numeral MathDifficultParse,Preparation,Data Analysis,Developer,Join,TransformAdvanced184Closest Pubs to Tobacco DockIntermediateSpatial Analysis,Spatial,Preparation,Reporting,TransformAdvanced185Amplify your Learning with Weekly Challenges!IntermediatePreparation,Data Analysis,Join,TransformAdvanced186Drilling down into Data AnalysisIntermediatePreparation,Data Analysis,Join,TransformAdvanced187Generate Prime NumbersIntermediatePreparation,Data AnalysisAdvanced188Difficult, but not im-parse-ableDifficultParse,Preparation,Data Analysis,JoinAdvanced189Billboard Top 100BasicPreparation,Data Analysis,Join,TransformCore190Supply Chain Management ChallengeIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformCore191BINGO!Basic,Intermediate,DifficultPreparation,Join,Data Preparation,Reporting,Transform,InterfaceAdvanced192Crane LeasingIntermediateParse,Preparation,Data Analysis,Join,Data Preparation,TransformCore193Unofficial HolidaysBasicParse,Preparation,Data PreparationCore194SANTALYTICS 2019BasicParse,Preparation,Data Analysis,Developer,ReportingAdvanced195XML ParsingDifficultParse,Preparation,Data AnalysisAdvanced196Determine Profit MarginIntermediateParse,Preparation,Join,Data Preparation,TransformCore197Customer Density ReportingIntermediateSpatial Analysis,Spatial,Preparation,Join,Reporting,TransformAdvanced198Beverage InventoryIntermediatePreparation,Data Analysis,Join,Data Preparation,TransformCore199Let's all go to the movies!IntermediateSpatial Analysis,Spatial,Preparation,Join,Data Preparation,Reporting,TransformAdvanced200Sudoku SolverBasic,Intermediate,DifficultParse,Preparation,Data Analysis,Join,TransformAdvanced201Wage Ain't Nothin' but a NumberIntermediatePreparation,Data Analysis,Join,ReportingAdvanced202Love PoetryIntermediateParse,Preparation,Transform,Apps,InterfaceAdvanced203Everyone loves a toll boothIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced204Updating BrazilIntermediateSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced205TaynalysisBasicParse,Preparation,Join,Data Preparation,TransformCore206Hotel ReservationsBasicParse,Preparation,Data Preparation,TransformCore207Parsing Video Game DataIntermediateParse,Preparation,Data Analysis,Developer,JoinAdvanced208COVIZ-19DifficultParse,Preparation,Data Analysis,Join,ReportingAdvanced209Parsing Insurance ClaimsDifficultParse,Preparation,Data Analysis,Join,TransformAdvanced210Better Late Than NeverIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced211Generating Email AddressesBasicParse,Preparation,Data Analysis,TransformAdvanced212Draft MastersBasicPreparation,Join,Data Preparation,TransformAdvanced213Optimized Flower ArrangementsIntermediatePredictivePredictive214US Military and High PointsIntermediateSpatial,Parse,Preparation,Data Analysis,TransformAdvanced215Gotta Catch 'em All!IntermediatePreparation,Transform,Apps,InterfaceAdvanced216The Big FiveIntermediatePreparation,Data Analysis,Join,TransformAdvanced217A Fast Blast From The PastIntermediatePreparation,Data Analysis,Join,TransformAdvanced218Car Sales ReportingIntermediateReportingAdvanced219Who Runs The World? GirlsBasicParse,Preparation,Data PreparationCore220Hedge DetectionDifficultSpatial Analysis,Spatial,PreparationAdvanced221Avocado ConsumptionIntermediatePreparation,Data Analysis,TransformCore222Where There's a Whale There's a WayBasicPreparation,Data Analysis,JoinCore223Going NuclearIntermediatePreparation,Data Analysis,Join,TransformAdvanced224Mushroom for ImprovementIntermediateData PreparationCore225How Long Has It Been?IntermediateApps,InterfaceAdvanced226Flex-AbilityBasicSpatial Analysis,Spatial,TransformAdvanced227/*comments*/IntermediateData PreparationCore228Know Your BoundariesDifficultSpatial Analysis,Spatial,Preparation,Join,TransformAdvanced229Trend AnalysisIntermediateReportingAdvanced230Take a Look, It's in a Book!IntermediateParse,Preparation,Data Preparation,Reporting,TransformAdvanced231What a Combo!IntermediateParse,Preparation,Data Analysis,Join,TransformCore232That's Sew 2020IntermediatePreparation,Data Analysis,Join,TransformCore233The Truth Is Out ThereIntermediateSpatial,Preparation,Data Analysis,Join,Reporting,TransformAdvanced234Spell It Out For Me - Part 1IntermediateParse,Preparation,Data Preparation,TransformCore235Spell It Out For Me - Part 2IntermediatePreparation,Join,Data Preparation,TransformCore236I Thought It Was Channel Surfing?IntermediateSpatial Analysis,Spatial,Preparation,Reporting,TransformAdvanced237WarekiIntermediateParse,Preparation,Join,Macros,InterfaceAdvanced238Ideal Gases Don't ExistIntermediatePreparation,Transform,Apps,InterfaceAdvanced239SEND + MORE = MONEYIntermediatePreparation,Data Analysis,Join,TransformAdvanced240Every Vote Counts!IntermediatePreparation,Join,Transform,MacrosAdvanced241Friday the 13thIntermediatePreparation,Data Preparation,TransformAdvanced242Meet Me HalfwayIntermediateSpatial Analysis,Spatial,Parse,Preparation,TransformAdvanced243Odd Man OutIntermediatePreparation,Developer,Join,Data Preparation,TransformAdvanced244Cats and DogsIntermediateReportingAdvanced245Zip It Real GoodIntermediateParse,Preparation,Join,Data PreparationAdvanced246Rectangle TangleIntermediateSpatial,Preparation,Join,Macros,InterfaceAdvanced247Pairing PartnersIntermediatePreparation,Join,Data Preparation,TransformAdvanced248HolidatesBasicPreparation,Data Analysis,JoinCore249HighlightsIntermediatePreparation,Data Analysis,Join,Reporting,TransformAdvanced250Give Me A SignDifficultParse,Preparation,Join,Reporting,Transform,Apps,InterfaceAdvanced251LunacyDifficultSpatial Analysis,Spatial,Preparation,JoinAdvanced252Working Days RemainingIntermediateParse,Preparation,Join,Macros,InterfaceAdvanced253Delivery DatesBasicPreparation,Data Analysis,JoinCore254DATA-DRIVEN COCKTAIL RECIPE - PART 1IntermediatePreparation,Predictive,Join,Transform,Predictive AnalysisPredictive255DATA-DRIVEN COCKTAIL RECIPE - Part 2IntermediateData Investigation,Preparation,Predictive,Transform,Predictive AnalysisPredictive256Working Fore The WeekendIntermediateParse,Preparation,Data Analysis,Join,TransformAdvanced257PalindromesIntermediatePreparation,Join,Transform,Macros,InterfaceAdvanced258Relatively OldBasicPreparation,Data Preparation,TransformCore259DisenvowelIntermediateParse,Preparation,Join,Data Preparation,TransformCore260Fuel Me Once...IntermediateParse,Preparation,Data Analysis,Join,TransformCore261Car Service RemindersIntermediatePreparation,Join,Data Preparation,Reporting,TransformAdvanced262With-invoiceDifficultParse,Preparation,Join,Data Preparation,TransformAdvanced263Supernatural 7-SphereBasicPreparation,Join,Apps,InterfaceAdvanced264Sliding TotalsIntermediatePreparation,Data Analysis,Join,TransformAdvanced265Keep In TouchDifficultSpatial,Parse,Preparation,Data Analysis,Join,Reporting,TransformAdvanced266Mother's Day BouquetIntermediateSpatial Analysis,Spatial,Macros,InterfaceAdvanced267To Quote The AlphabetIntermediateParse,Preparation,Data Analysis,Join,Transform,MacrosAdvanced268Definitely Not Made UpIntermediatePreparation,Join,Data Preparation,TransformCore269Population DenCitiesBasic,Intermediate,DifficultSpatial,Preparation,Data AnalysisAdvanced270Pony PermutationsBasicPreparation,Data Analysis,Join,TransformCore271Dynamic Double DipBasicParse,Preparation,Join,Data Preparation,TransformCore272Configure It OutBasicPreparation,Join,Data Preparation,Reporting,TransformAdvanced273Filling In The BlanksBasicPreparation,Join,Data Preparation,TransformCore274ConcattributesBasicParse,Preparation,Join,Data PreparationCore275Greatest Common DenominatorDifficultPreparation,Data Analysis,Join,TransformAdvanced276Getting Star-tedBasicSpatial Analysis,Spatial,Preparation,JoinAdvanced2772016 Summer OlympicsIntermediateParse,Preparation,Data Analysis,Join,TransformCore278Women Athletes and The OlympicsIntermediatePreparation,Data Analysis,Reporting and Visualization,Join,Reporting,TransformAdvanced279How many Olympic Games per Continent?IntermediateParse,Preparation,Data Analysis,Join,TransformCore280Weather PermittingIntermediateParse,Preparation,Data Analysis,Join,TransformCore281HolidaysBasicPreparation,Data Preparation,TransformCore282Analyzing EarthquakesIntermediateSpatial Analysis,Spatial,Reporting and Visualization,ReportingAdvanced283The Summer Paralympic Games 2020BasicData PreparationCore284Division with MacrosDifficultMacrosAdvanced285Around the worldIntermediateReporting and VisualizationAdvanced286Who turned the lights off?BasicData AnalysisFoundation287Find My Pet USBasicSpatial,Join,Data PreparationAdvanced288Client's Rating AnalysisBasicData Analysis,Data PreparationFoundation289Prep a Shoe ListParse,Data PreparationAdvanced290Unlock a World of OpportunitiesParse,Data PreparationAdvanced291A Winning Halloween Candy BasketBasicData PreparationFoundation292It's about Pivoting, Prepping and Reporting!IntermediateReporting and Visualization,Data PreparationAdvanced293Top 5 ArtistsBasicData Analysis,Data PreparationAdvanced294Formula 1 CircuitsIntermediateSpatial Analysis,Spatial,Preparation,ReportingAdvanced295Thanksgiving FeastBasicPreparation,Data Preparation,Reporting,TransformAdvanced296Breaking News - Headlines and KeywordsBasicData Analysis,Data PreparationCore297Rubik CubeIntermediatePreparation,Data Cleansing,Join,Data PreparationAdvanced298Christmas Treasure BoxBasicPreparation,Join,Data Preparation,TransformCore299Globetrotting SantaIntermediateSpatial Analysis,Spatial,Join,ReportingAdvanced300Where is the party?BasicData Analysis,Data PreparationFoundation

https://community.alteryx.com/t5/Weekly-Challenges/Challenge-335-Movie-Decisions/td-p/996467 https://community.alteryx.com/t5/Weekly-Challenges/Challenge-338-Let-s-Summarize/td-p/1006565 https://community.alteryx.com/t5/Weekly-Challenges/Challenge-331-Time-for-College/td-p/980575 https://community.alteryx.com/t5/Weekly-Challenges/Challenge-321-Eurovision/td-p/945433 hope these links can help!

Thank you for this. Where can I find the following challenges? 335, 338, 331, 321

Thank you so much @JoeM , much appreciate and very useful to me as newbie in Alteryx Regards, Andreas

Weekly Challenge Index & Welcome (Page 1)

JoeM

Welcome to the Weekly Challenges!

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)

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

Macros

Apps

Data Analysis

Intermediate

Data Preparation

Predictive

Basic

Spatial

Data Cleansing

Data Parsing

Difficult

Accepted answers

All comments

SeanAdams

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

Thank you, @JoeM! So helpful!

Subratdas

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

Subrat

PaulRB

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

@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

Thanks JoeM!

SeanAdams

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

@SeanAdams

JoeM

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!

JohnHG

Hi,

I am brand new to this, never really worked with Alteryx, more with SAS Enterprise Guide / Miner.

So I would like to go through these weekly challenges.

I've downloaded the first one, and found out it opens Alteryx, but there's no data file. How do I start, where do I find the data source?

Thanks,

John

SeanAdams

Hey @JohnHG,

the weekly challenges generally have a text input on the top-right hand corner, which contains your input data. There's generally a second text intput on the top right that has the expected output data.

The challenge then is to build an alteryx process in the middle to transform the input data into the same result as provided in the sample output.

I've attached an annotated screenshot below - hopefully that helps?