Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #357: College Majors in High Demand

acarter881
12 - Quasar

Here's my solution. Few comments: 1. There's a static way of solving this by splitting immediately by columns, but the dynamic way scales much better. 2. Not sure why there's a field called Unemployment_rate in the sample output.

Spoiler
acarter881_0-1675706374291.png

 

alexnajm
17 - Castor
17 - Castor

Extra "unemployment_rate" field in the sample output, otherwise nice and simple challenge!

Spoiler
Challenge 357.PNG
TonyAndriani
9 - Comet

 

Spoiler
TonyAndriani_0-1675707459505.png

 

 

 

elaineyuan
8 - Asteroid

I appreciate the directions.

 

Spoiler
challenge_357_elaine_yuan.png
robbinrv
8 - Asteroid
Spoiler
robbinrv_0-1675708913933.png

 

ed_hayter
12 - Quasar
Spoiler
ed_hayter_0-1675709371590.png

 

JPPPP
8 - Asteroid
Spoiler
Solution attached

JPPPP_0-1675709581363.png

 

mhgarcia
8 - Asteroid

My solution attached

Clifford_Coon
11 - Bolide

My Solution:

A couple of Notes:

-  Unemployment rate calculation is not given.

        I used  UnEmployment_Rate = [Unemployed] / ([Employed]+[Unemployed])

- % Employed the example is not rounded. It is actually truncated to the next largest integer (see results grid)

Spoiler
challenge_357.jpg

Reesetrain2
9 - Comet
9 - Comet

All,

 

My solution:

No  Data Science in the top ten though...

Spoiler
Capture.PNG