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

daniel_ferreira
8 - Asteroid

Follow my solution file attached...

Fz
8 - Asteroid

Hello,

 

I am trying to use your solution. When I run woorkflow as analytic APP and regardless of  the position number i choose. I have as results " there were No output Files". Any help please ? I am o beginner in alteryx . 

I join a screenshot 

Thank you ,screenshot.PNG

JacobR77
8 - Asteroid

Fun to practice.

petgrap
8 - Asteroid
Spoiler
Challenge 5.JPG
jxuan
7 - Meteor
 
mascarenhas_lucas
8 - Asteroid

Here's my solution! It's is little bit extensive because I didn't want to populate the dropdown manually.

And thanks to @NicoleJohnson who showed how to display the result from a browser tool.

 

Spoiler
challenge_5.PNG

 

lundarius
6 - Meteoroid

My version

StevenBetts
8 - Asteroid

This was my first app so it was a bit of a learning curve. Had to peek at a few people's solutions to figure some of it out - particular thanks go to @PhilipMannering for saying how to auto-populate the drop-down from the unique values list!

jut
7 - Meteor

Finished my first weekly challenge! Solution attached.

mmongeon
8 - Asteroid

Here is my solution.

 

Spoiler
This kind of Analytic App shows what I consider to be a weakness of Alteryx: being unable to easily use workflow data to populate interface tools (drop-down).
If workflows had an Initialization section, invoked before the interface tools are displayed, it seems like this could be possible.

In my workflow, I've created a section that will produce a distinct list of Position Numbers, that can be "copied and pasted" into the drop-down list configuration.
Then I decided to re-use this to perform a (pseudo) cross-join on the hierarchy data, in the filter I remove any invalid links between position numbers and the hierarchy and I filter on the selected Position Number.
workflow 5.JPG