11 Replies Latest reply: Dec 13, 2016 9:50 AM by kalyani vintha1 RSS

    Load data from Two or more Tables simultaneously

    Eric Vilarrasa Canadell

      Hi, the idea behind my question is so simple, and I think that the solution will be so. I have two tables loaded from excels with different data and, to create a 3rd one I need to access on both simultaneously :

       

      Table 1:   [Product Serial Number]

                      [Failure Date]

       

      Table 2:  [Product Serial Number]

                     [Product Installation Date]

       

      My aim is to create a 3rd table with the amount of time between [Failure Date] - [Installation Date] as a variable.

       

      Nowadays my solution is to left joint table 1 and table 2 but what I want is to have It in separate if it is possible.