it sounds like you are on the right track, only the EmployeeID from both sheets should associate, if you have other fields that are similiar you may have to rename thm first. Would you be interested in attending the getting started with Qlik Sense Webinar today at 2PM EST - where I cover most of this type of thing?
You can register here:
Also check out this quick video about Synthetic tables and it shows you how to resolve them:
available from: Your Qlik Sense in 60
Other videos that may help you get started:
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Let us know how you do.