Challenge #5: HR Position Finder Application

[SilviaRox]

Hi there,

this was my first weekly challenge about analytic app !

Silvia

[jarrod]

did it two ways - one with a simple filter and one that transposes, appends, joins and uses an updated text input action. both have their merits.

Spoiler

[DavidLane]

I originally skipped this one as I am not that familiar with app interfaces, but as I have become more involved with macros this seems more straight-forward

Spoiler

[YomaraA]

Here is my solution!

Spoiler

[balajilolla]

Spoiler

Solution Attached

[G_Thompson]

My first real stab at an App!

[deviseetharaman]

Spoiler

[NapasornCh]

I used a very different approach to the solution to come to the same answers.

I chose to create a key field with some parsing and multifield formula involved.

See solution in pic and attached.

Spoiler

[NapasornCh]

To avoid manually set the drop down value

Spoiler

1. Use 4 select tools to rename all the fields to be the same name (e.g. position number, key, etc) and then union these four streams into one column.

2. Use cross-tab to turn this key column into separate field names

3. Feed these field names into the drop down tool

[NapasornCh]

Spoiler

1. Use 4 select tools to rename all the fields to be the same name (e.g. position number, key, etc) and then union these four streams into one column.

2. Use cross-tab to turn this key column into separate field names

3. Feed these field names into the drop down tool

Above is the method to avoid manually listing the drop down selections