Challenge #5: HR Position Finder Application

[Amarendra]

do you mind sharing a yxmd file? The file u uploaded is an app and I cannot check the underlying workflow. Can I check the workflow directly from an app?

[PhilipMannering]

@Amarendra Try opening it from File > Open Workflow in the Alteryx Designer. 

[dheerajpoojari]

Attaching my solution which is dynamic based on the input.

Spoiler

[jamielaird]

Here's how I approached this one.  Solution file attached.

Spoiler

1) Created a unique set of position numbers and transposed them to field names for use in a Drop Down tool.



2) Passed the selected value into the workflow and appended to the original source table, to create a 'match' value.



3) Found and filtered the matched records and outputted to a YXDB.

[Natasha]

Love the header trick from @PhilipMannering

Spoiler

[patrick_digan]

Spoiler

I like passing interface tools like %Question.Name% since it uses one less tool (no action tool). I used the arrange and crosstab tools to reorient the data so I populate the dropdown.

[jdunkerley79]

Don't build apps that often, nice example. And like the dynamic drop down solution

Spoiler

[vkarthik21]

Used the transpose alongside Row number method to obtain the result set. I still can't understand what tehse apps are all about. Will read up on them. Solution attached

[JoshKushner]

Please find my solution to challenge #5 attached. This was a great introduction to analytic apps!

[michael_d]

Fairly self explanatory this one, good practise for those who are unfamilar with building an Analytical App.

The only thing I don't like about them is I always find myself using the Fields from a connected tool option, would be nice to able to use unique records from a selected field or something like that!

Another down side with that option is that you must run the App as a workflow first, before you can see any options in the Apps dropdown menu, caught me out a few times.

Thanks,

Michael