Icon

EmployeeSkills

Employee Skills

A survey was done to ask employees to rate themselves on a scale of 1-5 on different technologies and skills. We would like you to analyze this data and present it in a list where we are providing primary, secondary, and tertiary skills. Primary skills can be defined as skills rated 5; secondary skills rated 3 and 4; and tertiary skills rated 2. The final list should appear as it does on the KNIME forum where this challenge was suggested:

1. Primary skill can be defined as skills rated 5, Secondary skills rated 3 and 4 and tertiary skills are rated 2. The final list should appear like below.

2. Top three skills as “Primary Skills”, Next five skills as “secondary Skills” and next 7 skills as “Tertiary skills”. There could be cases where an employee has not rated themselves more than 3 on any of the skill.

Note: There may be cases in which employees have not rated themselves more than 3 on any of the skills (i.e., they have no primary skills).

Employee IDRating 5 to 1Primary (5)Secondary (4-3)Tertiary (2)First sevenEmployee IDEmployee IDEmployee IDFirst threeFirst fiveExcel Reader Unpivoting Group Loop Start Sorter Row Filter Row Filter Row Filter Row Filter GroupBy GroupBy GroupBy Column Rename Column Rename Column Rename RowID RowID RowID Column Appender Loop End Row Filter Row Filter Employee IDRating 5 to 1Primary (5)Secondary (4-3)Tertiary (2)First sevenEmployee IDEmployee IDEmployee IDFirst threeFirst fiveExcel Reader Unpivoting Group Loop Start Sorter Row Filter Row Filter Row Filter Row Filter GroupBy GroupBy GroupBy Column Rename Column Rename Column Rename RowID RowID RowID Column Appender Loop End Row Filter Row Filter

Nodes

Extensions

Links