Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #153: And the Oscar goes to...

ChristineB
Alteryx Alumni (Retired)

A solution to last week's challenge can be found here

 

In case you missed it, the Oscars awards ceremony was held last night.  Also, in case you missed it, we made it easy to get caught up on the nominees and the winners of each award category!  

 

Using the provided dataset and look-up table to create an app to allow an end-user to select an award category.  Render the result as .pcxml to reveal the winner of that category! 

 

SPOILER ALERT: This challenge contains spoilers...if you want to read up on the award ceremony, it would behoove you to to do so before completing this challenge!

 

Fun Fact: Oscars weigh 8.5 lb and stand 13.5 inches tall!Fun Fact: Oscars weigh 8.5 lb and stand 13.5 inches tall!

 

patrick_digan
17 - Castor
17 - Castor

@ChristineB  I think some of the text for A star is born was cut off in the text input tool. Apparently it was nominated for too many awards!

patrick_digan
17 - Castor
17 - Castor
Spoiler
Here you go!
Capture.PNGCapture2.PNG
ChristineB
Alteryx Alumni (Retired)

@patrick_digan  Great catch!  Should be fixed now. 

cplewis90
13 - Pulsar
13 - Pulsar

This was fun and I think a follow up challenge could be around some survey data gauging how audiences reacted to having no host this year. 

I still think the issue @patrick_digan brought up still exists in the file saved. I created some formulas to make sure and include it. 

Spoiler
Challenge 153.PNG
danilang
19 - Altair
19 - Altair

Not enough bling in the requested image...Tinsel Town.

 

result.png

 

Spoiler
Solution.png

Dan

pasccout
8 - Asteroid

Here is my solution...

 

Spoiler
Workflow Result.jpg
cgoodman3
14 - Magnetar
14 - Magnetar
Spoiler
Challenge 153.PNG

Here's my solution. Struggled with getting the drop down filter to work, so ended up using the "connections from questions" option which works fine when it's an app but when testing you can't see what flows downstream. Plus is there a way to render the output in the interface designer?

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
karp
6 - Meteoroid

Here's my solution.  I also included a bit more to make sure that whichever Award Category is selected, the output will be displayed semantically correct.  See screen shots.

 

Edit: I'm having difficulty uploaded my solution file - receiving this error: The contents of the attachment doesn't match its file type

 

Spoiler
1.PNG2.PNG3.PNG

 

ChristineB
Alteryx Alumni (Retired)

@karp I know we've seen some issues with uploading .yxwz files in the past.  Try uploading your workflow as a .yxzp file and see if that helps!