Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #153: And the Oscar goes to...

Highlighted
Alteryx
Alteryx

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!

 

Highlighted
16 - Nebula
16 - Nebula

@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!

Highlighted
16 - Nebula
16 - Nebula
Spoiler
Here you go!
Capture.PNGCapture2.PNG
Highlighted
Alteryx
Alteryx

@patrick_digan  Great catch!  Should be fixed now. 

Highlighted
12 - Quasar
12 - Quasar

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
Highlighted
17 - Castor
17 - Castor

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

 

result.png

 

Spoiler
Solution.png

Dan

Highlighted
8 - Asteroid

Here is my solution...

 

Spoiler
Workflow Result.jpg
Highlighted
11 - Bolide
11 - Bolide
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?

Highlighted
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

 

Highlighted
Alteryx
Alteryx

@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!