Comparing Reference Column to Actual Column (text)

[Anonymous]

I am trying to track training status of employees, and identify which training each employee should take next, based on required/recommended courses and historical information. Following are some relevent tables. These tables can be changed to facilitate the analysis. Any help would be appreciated.

Required/Recommended Training by Role

Role	Required	Required	Required	Recommended	Recommended	Recommended	Recommended
Developer	Course A	Course B	Course F	Course G	Course H
BA	Course B	Course C	Course E	Course I	Course J	Course K	Course L
Tester	Course A	Course B	Course F	Course G	Course H
Manager	Course B	Course C	Course D	Course M

Historical Training

Course ID	Course	Start Date	End Date	Name
1	Course 1	4/1/2022	4/15/2022	John
2	Course 1	4/1/2022	4/15/2022	Jane
3	Course 2	4/16/2022	4/30/2022	Sarah
4	Course 2	4/16/2022	4/30/2022	Tom

Employee Role

Name	Role
John	Developer
Jane	BA
Sarah	Tester
Tom	Manager

[speedramps]

Unpivot "Required/Recommended Training by Role" to create a table with

Role and Course because tabulare tables are much easier to work with. 😀

Data clean the Course ID so the "Historical Training" and "Required/Recommended Training by Role" correspond because you cant not relate Course 1, 2,3 to Course A. B, C

.

Build a 1:M relationship from Employee Role[Name] to "Historical Training".

Build a 1:M relationship from Employee Role[Role] to "Required/Recommended Training by Role".

I think you will be able to do the rest, but ask if you need more help. 

I helped you so now please help me.

Click the thumbs up and Accept ad Solution to leav ekudos.
Thankyou 😀