This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
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!
The Solution has been uploaded.
The Solution to this Exercise has been uploaded.
Thank you for this exercise - well worth the time.
Things in my solution that are different to the provided 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? :)
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.
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.