Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #93: Pumpkin Production

ozdogand
Asteroid

my solution

Spoiler
ozdogand_0-1576560983069.png
Hjardine
Asteroid
Spoiler
Text to columns to get data clean, dynamic rename for field names from first row, join the two data sets. Summarize and join tools to calculate averages and max/min, formula tool to calculate difference. sort by year 


Hjardine_0-1576943710594.png
varunvarma87
Asteroid

Hello !

 

My solution to W93 challenge:

 

Spoiler
Capture.JPG
JamesCameron
Asteroid

My Effort

 

Spoiler
JamesCameron_0-1577697466241.png
joshuaburkhow
ACE Emeritus
ACE Emeritus
 
Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
getintodata
Asteroid

Here is my solution!

getintodata
Asteroid

Here is my solution!

jfone
Asteroid
 
Angela_Menegassi
Alteryx Alumni (Retired)

Never used that many Joins before but apparently I'm not alone!  XD

Aswin
Asteroid

My solution: