community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #5: HR Position Finder Application

Alteryx Alumni (Retired)

We hope you enjoyed last week's challenge. For the fifth challenge let’s look at building an analytic application.

An HR department has a defined hierarchy for job identification across the organization. Depending on the job, the position within the hierarchy can change.

 

The goal is to create an analytical application that allows a HR rep to enter a position # (in this example, 33333) and return all records where the position is found within the hierarchy system.

 

We have listed this as an intermediate challenge since parameterizing a workflow and converting it to an application is slightly more advanced however the workflow to answer the question should be beginner level. As always, we love to hear your comments. We hope you are having fun with the challenges!

 

UPDATE 12/14/2015:
The Solution has been uploaded.

Creative Director
Creative Director

The Solution to this Exercise has been uploaded.

Tara McCoy
Alteryx
Alteryx

Debug mode in the Interface Designer definitely helped me on this one. Displaying the values that were being passed in by the Action tool helped me figure out where I was going wrong.

 

Solution attached!

Nebula
Nebula

Thank you for this exercise - well worth the time.

 

Things in my solution that are different to the provided solution:

 

Spoiler
focused on making this data-aware to practice reading values from DB for interface

- Created a simple process to write all the positions in the provided dataset to a file
- Interface dropdown then reads from a data query (the file in first bullet) - this matches what we'd do if reading the positions from an HR database.   The provided solution uses a static list.
           - QUESTION: I couldn't get the interface component to read direct from a text input - is there an easy way to do this?
- The provided solution hard-codes a formula based on 4 levels.    I used a transpose and searched across the full space (feels like this would be more flexible in the case that more HR levels are added)
- I write the responses out to a file so that the user has some way to see the output
           - QUESTION: Do Analytical apps have the ability to bring up a simple results screen?   Similar to providing the output of a browse window to the Analytical App user so that they can see the result?

Solution attached

 

Alteryx Certified Partner
Alteryx Certified Partner

Good Morning @JoeM

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Magnetar
Magnetar

My solution.

 

@SeanAdams- you had a couple question about the app interface. See below my workflow image in the Spoiler for some thoughts/answers I might have found for both your questions? :)

 

Spoiler
WeeklyChallenge5.JPG

APP INTERFACE QUESTIONS:
1. Question regarding text input directly to the app interface... I found an article that at least explained why I COULDN'T do it the way I wanted to (i.e. create the list of positions in the workflow and then use that to populate the drop-down list directly). Which is I think maybe what you were trying to do too. Sounds like you have to either manually input in the drop-down configuration screen, or bring in the list from an external source. Article

2. Question about browse results window popping up in app when finished. You can select the browse tool you'd like to display results for in the Interface Designer configuration... see image below. I think that's what you were asking for? Hope that helps!

WeeklyChallenge5InterfaceDesigner.JPG
Alteryx Certified Partner

Finished challenge 5!  I created an output .csv file to check the app was working, there are probably other ways to validate this that I am unaware of.

Spoiler
challenge5.jpg
Pulsar
Spoiler
Spoilerimage.png
Asteroid

This was a little bit of a challenge because I haven't worked with the interactive tools very much.  First I had to review the "Build an App" tutorial in the Alteryx help menu.  After that, I was able to solve and pretty much did the same as the posted solution but included an output to Excel.

Alteryx Certified Partner

Annoying about not being able to populate the drop-down tool with input rows