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 #5: HR Position Finder Application

Highlighted
11 - Bolide

Highlighted
10 - Fireball
Spoiler
spoiler5.png

Been a while since I attempted dynamic dropdowns - looks like it works. Wouldn't allow me to attach yxwz, extension was changed to yxmd.

Highlighted
7 - Meteor

Done

Highlighted
8 - Asteroid

@SeanAdams With analytic apps, you don't get output unless you go to the Interface Designer (View menu) and select the tools whose output you want displayed.

Check the box "On Success - Show Results to User" and then choose the tools you want shown. (When you select a tool, its assigned number shows up at the top of its Configuration window.)

I'm not sure about your other question.

Highlighted
8 - Asteroid

Oops - I thought I was replying to the most recent thread, but it was the oldest! (Wish I could just delete my reply)

Highlighted
8 - Asteroid

Here's my solution. Like some others, I made the drop down dynamic based on the list provided rather than hard coding it.

I also populate the drop down directly in the flow rather than creating an external file as some did.

My solution would have been simpler if I had used the OR option in the filter instead of transposing, but I needed to transpose anyway to get the drop down populated.

Spoiler
clipboard_image_0.png

Note - had to change the file type from yxwz to yxmd to post.

Highlighted
Alteryx
Alteryx

Challenge completed. First workflow used to pull the list of unique value. Second workflow for the app and to filter values based on selection

Highlighted
6 - Meteoroid

Finished. Took me a while longer and went a little "off-piste" so got a bit more complex that the solution but I had great fun and learned at bit more. The reason was I wanted to do two things:

  1. be able to populate the drop-down list automatically
  2. be able to cope if another "Level" (column) was added

The bit that took a bit was getting a list of values for the drop-down. I must be missing something as seems odd that you can just have it populated from a list of values.

 

Spoiler
clipboard_image_0.png
Highlighted
Alteryx Partner
Spoiler
#5_solution.png
Highlighted
12 - Quasar

My solution:

 

Spoiler
Capture.JPG