Hi, this is my solution..I did it right and checked with the solution posted with the project too..but I have a query.
When Data with average score was joined with Benchmark data, all the records were joined except Data regarding Training dept was left unjoined..So I ended up with 15 records after the join rather than 20 records ..What can be reason behind it? I have done it several times and concluded with the same problem.I am little unsatisfied with results..
Here's my solution, there are probably better ways of doing it.
@Harkamal I have found the error in your workflow. It is only the "Training department" that doesn't match, so I checked your data it is not a field type issue. You seem to have typed up the department names in a text file and there is a typo.
My attempt!
Thanks! @brig ..Fixed it..Capstone Project done!