4 Replies Latest reply: Oct 20, 2016 12:36 AM by Arpit Kharkia RSS

    Date as 'key for linkage' issue

    Arpit Kharkia

      Hi all,

      Currently im working on a project which has three tables. The data source of these three tables is an excel file. All these tables have date field in common apart from one other field. I want a combination of the two as my key so as to remove synthetic key.

      The issue im facing is that all the three date fields are in different range. For example if one date say 14-10-2016 is present in table A then its not present in the other two and vice versa. So after combing the two keys all the data is not linked with each other properly as I may select some date which is not present in other tables hence missing out on data.

      Looking for solution asap!