26 Replies Latest reply: Apr 13, 2016 5:23 AM by Андрей Шепель RSS

    Joining dates

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

      Good day!

      Colleagues, i have some simple model to understand how to join (fill) values by some key field.

       

      I load main table from sheet S1:

       

         

      IdDateSales
      101.01.201634
      104.01.20167
      106.01.20162
      107.01.20165

      then i need to join to this table all dates by Id field from sheet S2.

       

      My necessary result table:

         

      IdDateSales
      101.01.201634
      102.01.2016-
      103.01.2016-
      104.01.20167
      106.01.20162
      107.01.20165
      110.01.2016-

       

       

      Help, please!