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
7 - Meteor

Dynamically adds job position to drop down menu.

Highlighted
6 - Meteoroid

I feel like I missed a more obvious solution to populating the UI field...oh well. Got the solution anyway.

Spoiler
workflow and analytic appworkflow and analytic app
Highlighted
8 - Asteroid
Spoiler
5.PNG
Alteryx Community Team
Alteryx Community Team

Here is my solution

Highlighted
7 - Meteor
Spoiler
challenge 5_JB.png
Highlighted
8 - Asteroid

Here we go

Highlighted
12 - Quasar

Solution uploaded as workflow.

Highlighted
6 - Meteoroid

I decided to keep the filter simple and use a join while eliminating anything from the left group so that I could keep the original rows as they were, I also decided to automatically populate the drop down with the available positions by creating a unique set of the Job ID's and then cross tabbing the results so the values are the column names before connecting it to the Drop Down.

Spoiler
clipboard_image_0.png

It didn't want to let me upload as an App so it is not going to run as such if downloaded 

Highlighted
Alteryx Partner

Challenge 5 complete

Highlighted
8 - Asteroid
Thank you for the exercise - I propose 2 solutions - the first one with one apps and the second with 2 chained apps to update the list used in the drop down tool.