1 Reply Latest reply on Nov 24, 2016 12:10 AM by Vasil Petkov

    Join on an independent column but identify table

    michael.wu

      I have 3 tables that I need to join and there's no unique column unfortunately. There are dates that are in common so I created a shell table that just has individual dates for a few years. Then I joined each table to that by date. Now, the issue I run into is identifying unique records from each table. I thought it would be something like. I want to create a calculated field that will Color+ID. Since the ID's overlap and so do the dates, the calculated field doesn't come out right.

       

      TABLE1

      Date
      1/1/16
      1/2/16
      1/3/16
      1/4/16

       

      TABLE2

      Date
      Id#Color
      1/2/167BLUE
      1/4/169BLUE

       

      TABLE3

      Date
      Id#Color
      1/1/167GREEN
      1/1/1619GREEN

       

      TABLE4

      Date
      Id#Color
      1/3/163RED
      1/1/164RED