Consulting

Results 1 to 2 of 2

Thread: Bringing together 2 sets of data

  1. #1

    Bringing together 2 sets of data

    Hi all,


    I have to set of data. Both lists have a Employee reference which is unique to each person.


    First: List of all positions people have ever had in the company with start and end date.


    Second: List of all the salaries people have had within the company with a start and end date.


    I need to bring this data together. However, if someone has had more than one salary between the start and end date of a position i need to insert a row with the same position details but each row will contain the 2 different salaries.


    I have tried to do an example below.


    Basically Employee 1 has had 2 positions but only 1 salary - so out the outcome they have 2 lines for each position but the same salary for both.


    Employee 3 has had 2 positions but had a change in salary in the first one - so the outcome shows 2 lines for the first position because they had a salary change. Then the second position has one line because although its a new salary it started the same day as the position change.






    I hope this makes sense. I just chant get my head round how to do this.


    Thanks
    Chris

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •