Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #5: HR Position Finder Application

Highlighted
6 - Meteoroid

For some reason I can't upload the Analytic App, so uploading the workflow instead.

Highlighted
8 - Asteroid
 
Highlighted
Alteryx Partner
Spoiler

5. Apps Screenshot.PNG

Useful Challenge!

 

 

Highlighted
7 - Meteor

My Solution

Highlighted
7 - Meteor

Here is my solution.

Actually, I didn't understand very well the challenge statement.

So I put two outputs:

  1. One using the value provided in the second text input (containing the value 33333).

  2. One using the value selected by the user in the interface. The interface is fully dynamic.

Highlighted
Alteryx Certified Partner

I'll show you how to build dynamic apps, @Shifty  ;)

Highlighted
Alteryx Certified Partner

Very cool, and a nice introduction to dynamic parameters in Alteryx:

 

Spoiler
I first applied a record ID to every row, then I needed to take a stream off in one direction to create the list of possible numbers for the drop-down selection window. This is a bit idiosyncratic in Alteryx in that the drop down list is populated from the column headers rather than the row contents, but anyway...
So, I transposed the data so I had the record ID and the number from every column in one column. I then filtered out the null fields and used the sum tool to group by number and take a count. Cross-tabbing this allowed me to use the numbers as the headers and the count as the value. Once I had the numbers as the headers, I fed this into a "Dropdown" tool and gave it the appropriate question.
Once I had this, I placed a filter on the original transposed data and connected the "Dropdown" tool. In the "Action" tool, I set it to overwrite the selection with the dynamic value.
This I then joined back to the original data using the RecordID.
Workflow.PNGQuestion Window.PNG

results.PNG

NOTE: To see your output when building this, place a browse tool after the last join, open the "Interface Designer" window from the "View" menu and ensure you have configured it to show results on the browse tool:

interface designer.PNG

When you're ready, rather than using the standard run button, use the wand.PNG button. This will prompt you with the pop-up window.

Done.

For some reason it won't allow me to upload .yxwz  files, so I've uploaded as a standard workflow.

Highlighted
6 - Meteoroid

Here is my attempt

Highlighted
8 - Asteroid

Feels Pretty Clunky but was able to configure the app to get it to accept the input and generate accurate results!

 

 

Highlighted
8 - Asteroid

OK, first of all I was trying to populate the drop down using the values from the input so I take all of them in consideration. I was not able to make it work even it says on the help that should be possible using a connected tool.

Long story short I just populate the drop down using a list of fixed values.

PD: For some reason I was unable to load my yxmz file.