Create hierarchy based on column labels

[#1]

Hi All,

I have a list of people and their associated skills. These skills need to be categorised as either technical skills, soft skills or process specific skills.

The data has been provided to me in the format below:

Name	Skill 1	Skill 2	Skill 3	Skill 4	Skill 5	Skill 6	Skill 7	Skill 8	Skill 9
Joe Bloggs
Jane Bloggs

For example how can I group Skills 1-3 as 'Technical', Skill 4 & 9 as 'Soft-Skills' and Skills 5 - 8 as 'Process skills'?

Many thanks,

A

[Gysbert_Wassenaar · Accepted solution]

My recommendation would be to use the Crosstable function to transform the data to a table with the fields Name and Skill:

Skills:

Crosstable(Skill, Skillname)

load * from ...somewhere...;

That will give you a table like:

Name, Skill, Skillname

Joe Bloggs, Skill 1, abc

Joe Bloggs, Skill 2, cde

...etc

You can then create a skill groups table to link groups to skills:

Groups:

load * inline [

Skillgroup, Skill

Technical, Skill 1

Technical, Skill 2

Technical, Skill 3

Soft, Skill 4

Soft, Skill 9

Proces, Skill 5

...etc

];