Forum Discussion
Comparing Reference Column to Actual Column (text)
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 |
1 Reply
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 😀
