6 Replies Latest reply on Oct 10, 2019 9:24 PM by Shekhar Hazari

    Many to Many Relationships

    Sarah Boltwala-Mesina

      I have two worksheets in my excel file.

       

      SPREADSHEET 1 has the following layout.

      Hub NameDateBatch# of carts
      OVGG12/29/18A193.5
      GA-A171/4/2019A19
      OVGG1/5/2019A194.5
      MesaCollege1/6/2019A192
      GA-A171/11/2019B192
      OVGG1/12/2019B193.5

       

      SPREADSHEET 2 has the following layout.

       

      HubDateA19B19
      GA-A171/4/201973
      OVGG1/5/2019120
      GA-A171/11/2019100
      OVGG1/12/2019132
      MesaCollege1/13/2019100
      GA-A171/18/20198488
      OVGG1/19/2019119124
      MesaCollege1/20/2019100
      MesaCollege1/23/2019110
      GA-A171/25/201972115
      OVGG1/26/2019106128
      GA-A172/1/201979135
      OVGG2/2/201995116
      MesaCollege2/3/2019110100
      GA-A172/8/20198088
      OVGG2/9/201912995
      MesaCollege2/10/2019100110
      GA-A172/15/20198493
      OVGG2/16/2019103100

       

      As you can see every batch (for e.g. A19) at hub (for e.g. OVGG) has several row entries in Table 1. It also has several temperature readings for various days in Table 2. I want to create a relationship that links the batch A19 in table 1 to the batch A19 in Table 2. How do I do this?