Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How can I start a sequence with a specific value existic on a previous step?

  1. #1

    Default How can I start a sequence with a specific value existic on a previous step?

    Hi!

    Everything is on the title and title is everything, but :
    step 0 : a file with a few columns "...;...;...;ID;...;...;"

    step 1 : On request on my database "select id as MY_ID, max(index) as MAX_ID from table group by id" wich give me this result

    Name:  screenshot.341.png
Views: 15
Size:  1.4 KB

    step 2 : sequence "alpha"

    • must change if "id" change
    • must start with specific "max"


    I try to use both sequences but I can't see where to put my value to start the sequence properly
    pdi-ce-4.4.0-stable
    jdk1.7.0_09
    Intel Core I3-2330M@2.2Ghz - 8Go ram
    Windows 7 FEP SP1

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

    Default

    Quote Originally Posted by jcachico View Post
    I can't see where to put my value to start the sequence properly
    Just use 1 as start value and a Calculator step to add max_id.
    So long, and thanks for all the fish.

  3. #3

    Default

    Once again you're my hero marabu

    Name:  bisous-coeur.gif
Views: 15
Size:  17.1 KB
    pdi-ce-4.4.0-stable
    jdk1.7.0_09
    Intel Core I3-2330M@2.2Ghz - 8Go ram
    Windows 7 FEP SP1

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.