7 Replies Latest reply: Dec 26, 2015 9:19 AM by Sunny Talwar RSS

    Joining tables

    Андрей Шепель

      Good evening,colleagues!

      I have simple example to solve my real problem.

       

      In firtst load source i have three fields:

      WareHouse,

      Nomenclature

      Date

       

      Second:

      Date

       

       

      I need that every date from second soruce will be connected with every Nomenclature and every WareHouse (of cource, without dublicated dates, if some of them match in first source.

       

      My necessary table:

       

       

          

      WareHouseNomenclatureDateVolume
      13301.01.201510
      13304.01.2015
      13305.01.2015
      14502.01.201520
      14504.01.2015
      14505.01.2015
      14603.01.201521
      14604.01.2015
      14605.01.2015