3 Replies Latest reply: Jun 16, 2016 3:50 PM by Nenad Vuković RSS

    Best way to create additional rows based on the from-to periods

    Nenad Vuković

      Hi, is it possible to write a script to read the Source table and create a Result table in order to be able to show the trend line by periods?

       

      Thank you

       

      Source:

      load * inline [

      FromYY-MM, ToYY-MM, Amount

      16-09, 16-12, 1

      16-11, 17-02, 2];

       

      Result:

      load * inline [

      FromYY-MM, ToYY-MM, Amount

      16-09, 16-09, 1

      16-10, 16-10, 1

      16-11, 16-11, 1

      16-12, 16-12, 1

      16-11, 16-11, 2

      16-12, 16-12, 2

      17-01, 17-01, 2

      17-02, 17-02, 2];

       

      drop table Source;