Icon

KNIME_​challenge19_​solution

KNIME_challenge19_solution
Challenge 19: Employee SkillsLevel: MediumDescription: A survey was done to ask employees to rate themselves on a scale of 1-5 on different technologies andskills. We would like you to analyze this data and present it in a list where we are providing primary, secondary, andtertiary 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. Note: There may becases in which employees have not rated themselves more than 3 on any of the skills (i.e., they have no primaryskills).Author: Jyotendra ReadSkill_survey_data.xlsxfrom hubtidydata formatgroup skills5=>prim3,4=>sec2=>tert1,0=>no skillconcatenateper skill grouppivotskill groupsremoveno skills Excel Reader Unpivoting Rule Engine GroupBy Pivoting Row Filter Challenge 19: Employee SkillsLevel: MediumDescription: A survey was done to ask employees to rate themselves on a scale of 1-5 on different technologies andskills. We would like you to analyze this data and present it in a list where we are providing primary, secondary, andtertiary 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. Note: There may becases in which employees have not rated themselves more than 3 on any of the skills (i.e., they have no primaryskills).Author: Jyotendra ReadSkill_survey_data.xlsxfrom hubtidydata formatgroup skills5=>prim3,4=>sec2=>tert1,0=>no skillconcatenateper skill grouppivotskill groupsremoveno skills Excel Reader Unpivoting Rule Engine GroupBy Pivoting Row Filter

Nodes

Extensions

Links