2 Replies Latest reply: Jun 1, 2016 11:37 AM by Ludvig Ã…berg RSS

    Autogenerate dates in a certain range

    Ludvig Ã…berg

      Hello! I have data in the format of the table below:

       

      start_datecompany_namepay_model
      2015-10-01Company11
      2015-12-01Company21
      2016-01-01Company32
      2015-12-01Company46

       

      I want to expand the table to showing dates up to 2016-01-01 for each company:

       

      start_datecompany_namepay_model
      2015-10-01Company1

      1

      2015-11-01Company1

      1

      2015-12-01Company11
      2016-01-01Company11
      2015-12-01Company21
      2016-01-01Company21
      2016-01-01Company32
      2015-12-01Company4

      6

      2016-01-01Company46

       

      So far, i've auto generated the dates but all my solutions gives each company_name the same time span, Company1 spans from 2015-10-01 to 2016-01-01 (which is correct) but so does also the other companies.

       

      Any suggestions on how this can be achieved?