Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Sequence

  1. #1
    Join Date
    Oct 2007
    Posts
    25

    Default Sequence

    Hello all.

    Is there a way to specify the "Start at Value" property from the "Add Sequence" object within a transformation? I would like to go to database and check the next autoincrement value, so I can generate it in the transformation.

    I tried the "Use DB to get Sequence" but MySQL doesn't have sequence objects, therefore I believe this feature cannot be used with mysql database....


    Many thanks,
    Gustavo

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

    Default

    Just get the current value from the database, called A.
    Then generate a sequence starting from 0, called B.
    Then do ID = A+B (calculator step)

    (Use a cartesian join to slip A into the stream of data)

    HTH,

    Matt

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.