Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #5: HR Position Finder Application

Highlighted
Asteroid

Can't upload my app workflow! I receive an error message.

 

Spoiler



Spoiler
Capture.PNG

 

Highlighted
Meteoroid

It's been a while since I've created a new app. To start I was trying to make it more complicated than it needed to be before I worked out I was trying to do much more than was needed!

Highlighted
Alteryx
Alteryx

Pretty fun!

 

Spoiler
Good example of using the 'Q' Interface tool connection type.

Can't get my app to load though. 

Cailin Swingle
Sr. Manager, Customer Support
Highlighted

Has the start file been changed?

What i currently see is Position Number "3333" Int16,

while acc to your solutions it used to be  "33333" Int32 ?

 

Highlighted
Asteroid

The text input is missing a "3", so I just added it and continued with making a solution.

Highlighted
Asteroid
Spoiler
Challenge 5 2019-11-28.jpg
Highlighted
Asteroid
Spoiler
Annotation 2019-12-01 154417.png
Highlighted
Asteroid

image.png

Asteroid

Was able to build a solution

Spoiler
using transpose,summarize, filter and join. PFA.

Regards,

TD

Highlighted
Meteor

Interesting introduction to dynamic drop-downs. I've seen some solutions manually enter a list but needs amending each time there's a change in hierarchy. Couldn't get the browse tool to display the matching records on screen so had to use an Output tool to send them to a csv instead.