Icon

justKnimeit-19

justKnimeit-19
Challenge 19: Employee SkillsDescription: 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 toanalyze 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 wassuggested. 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 primaryskills). Read SkillsUnpivot withEmployeeIDGroup byEmp.Id and SkillPoints to GroupsPoints to GroupsPivot with GroupsSet -> Stringremove "[","]"Set -> Stringremove "[","]"Set -> Stringremove "[","]" Excel Reader Unpivoting GroupBy Cell Replacer Table Creator Pivoting String Manipulation String Manipulation String Manipulation Challenge 19: Employee SkillsDescription: 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 toanalyze 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 wassuggested. 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 primaryskills). Read SkillsUnpivot withEmployeeIDGroup byEmp.Id and SkillPoints to GroupsPoints to GroupsPivot with GroupsSet -> Stringremove "[","]"Set -> Stringremove "[","]"Set -> Stringremove "[","]" Excel Reader Unpivoting GroupBy Cell Replacer Table Creator Pivoting String Manipulation String Manipulation String Manipulation

Nodes

Extensions

Links