Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Explode rows

  1. #1

    Default Explode rows

    Hi! I am trying to explode a row in 12 row like the example below:

    year budget
    2000 120
    2001 240
    2002 360

    and now explosion:

    year month budget
    2000 1 10
    2000 2 10
    2000 3 10
    2000 4 10
    ................................
    2000 12 10
    2001 1 20
    2001 2 20
    ......ecc...................


    any idea?

    thank you!!

    Matteo

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Join with 12 months (1 through 12, use a sequence).
    Then I guess you simply divide the the budget by 12.

  3. #3

    Default

    It works! :-D thank you!

    Matteo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.