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 rel...
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 😀