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

bklninjah
7 - Meteor

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

CRowlatt
8 - Asteroid
 
TimothyManning
8 - Asteroid
Spoiler

5. Apps Screenshot.PNG

Useful Challenge!

 

 

mgcarrenard
7 - Meteor

My Solution

pfredin
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.

mceleavey
17 - Castor
17 - Castor

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



Bulien

mceleavey
17 - Castor
17 - Castor

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.



Bulien

bdjw
6 - Meteoroid

Here is my attempt

rslopez2
8 - Asteroid

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

 

 

RobertoEstrada
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.