I'm quite stumped on this issue.
The data that I have is about people, jobs, and knowledge areas.
1 table lists people and the knowledge areas they indicated so
peopleID k1 k2 k3 k4 k5 k6 ...k25
a person can select 0 or all 25 knowledges
for the jobs, i have made a new table that lists the top5 knowledge areas for that job
jobID KnowID Value
A k2 4.5
A k4 3
I can transform that table to be also
jobID k1 k2 ... k25 and there would only be 5 knowledge columns with values for each row.
What I want to do is select jobs that match the knowledge areas that people have selected.
Where I'm stumped is if a person has more than 5 knowledge areas, how do I see if 5 of like the 10 selected match the top5 for that job. Somehow I have to figure out all the combinations for what they've selected right?
ANy help woudl be great. I need to run this for a meeting tomorrow.