Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Amarendra
10 - Fireball
do you mind sharing a yxmd file? The file u uploaded is an app and I cannot check the underlying workflow. Can I check the workflow directly from an app?
PhilipMannering
16 - Nebula
16 - Nebula

@Amarendra Try opening it from File > Open Workflow in the Alteryx Designer. 

dheerajpoojari
7 - Meteor

Attaching my solution which is dynamic based on the input.

Spoiler
challenge5.png
jamielaird
14 - Magnetar

Here's how I approached this one.  Solution file attached.

 

Spoiler
1) Created a unique set of position numbers and transposed them to field names for use in a Drop Down tool.

Screen Shot 2017-08-20 at 18.34.34.png

2) Passed the selected value into the workflow and appended to the original source table, to create a 'match' value.

Screen Shot 2017-08-20 at 18.34.45.png

3) Found and filtered the matched records and outputted to a YXDB.

Screen Shot 2017-08-20 at 18.34.55.png


Natasha
9 - Comet

Love the header trick from @PhilipMannering

 

Spoiler
Screen Shot 2017-08-27 at 11.36.26.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
I like passing interface tools like %Question.Name% since it uses one less tool (no action tool). I used the arrange and crosstab tools to reorient the data so I populate the dropdown.
Capture.PNG
jdunkerley79
ACE Emeritus
ACE Emeritus

Don't build apps that often, nice example. And like the dynamic drop down solution

 

Spoiler
2017-10-04_21-02-25.jpg

 

vkarthik21
8 - Asteroid

Used the transpose alongside Row number method to obtain the result set. I still can't understand what tehse apps are all about. Will read up on them. Solution attached

JoshKushner
12 - Quasar

Please find my solution to challenge #5 attached. This was a great introduction to analytic apps!

michael_d
8 - Asteroid

Fairly self explanatory this one, good practise for those who are unfamilar with building an Analytical App.

 

The only thing I don't like about them is I always find myself using the Fields from a connected tool option, would be nice to able to use unique records from a selected field or something like that!

 

Another down side with that option is that you must run the App as a workflow first, before you can see any options in the Apps dropdown menu, caught me out a few times.

 

Thanks,

 

Michael