Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: how to increment sequence??

  1. #1

    Default how to increment sequence??

    Hello all,
    It looks very silly problem but i have trouble with it..

    I want out put something like

    CutID Step_IN
    1 0
    1 1
    2 0
    3 0
    1 2
    1 3
    2 1
    2 2

    i am using Add value fields changing sequence step and based on this step getting below result

    And what i am getting in

    CutID Step_IN
    1 0
    1 1
    2 0
    3 0
    1 0
    1 1
    2 0
    2 1

    so suggest what to do for getting above result?

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    (1) Add a sequence SEQ to remember the original sort order
    (2) Sort by (CutID, SEQ) ascending
    (3) Add a group sequence STEP_IN
    (4) Reestablish the original order by sorting SEQ
    So long, and thanks for all the fish.

  3. #3

    Default

    Ohh yes i sorted the rows and problem is resolved..
    Thanks a lot marabu..

Tags for this Thread

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.