Forum Discussion

ambient_88's avatar
ambient_88
Frequent Visitor
8 years ago

Parent-Child relationship problem

Hello Guys,   I have a problem I've been trying to tackle but to no avail.   Problem: An employee can be transferred to a different supervisor in the middle of the month.   5/1 - 5/15    ...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

I think i can help here.  However, i notice that there is no Year in the data range of column D.  Do you not get the year from the source?  

  • ambient_88's avatar
    ambient_88
    Frequent Visitor
    8 years ago

    Hello,

     

    I should be able to get the year date for the column D.

     

    Thanks!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      Please share the exact date format in that case.  Infact, share the link from where i can download your Excel file and show the expected result there in a Table format.

      • ambient_88's avatar
        ambient_88
        Frequent Visitor
        8 years ago

        Hello,

         

        Here's the link for the sample data. 

         

        https://drive.google.com/open?id=1w9h1X_irjQJAlCNJyDvDgLqO9zcZGZwn

         

        As you can see, a person can be moved to a different supervisor within the month. With the way I have it set up right now, if a person moves to another team within the month, his/her score will transfer as well. We don't want that. The score under Supervisor A should stay under that supervisor.

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        I would appreciate if you can guide me as to how to design the data model for this. Right now I have two lookup tables (Employee and Date) and one data table (survey data).

         

        Thank you.