Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Please help with variable

  1. #1

    Unhappy Please help with variable

    Hello everybody,

    I'm getting mad trying to work with variables.
    My problem seems to be rather simple.
    I have a counter stocked in a table :

    • I create a SQL script job entry to get the current value of my counter :
      SELECT current FROM SequenceNo
    • I want to use the result of this query in the following job entry as the initial value of a sequence step.

    I'm playing unsuccessfully with the "SET_VARIABLES" job entry since 1 day now...
    If I create a variable with a numeric value, no problem my sequence step work is correctly initialized. My problem is how to assign to this variable the result of the SQL query ?

    I hope that if I can get this step working correctly I will be able to update my sequence table at the end of the job...

    Thank you for your attention,
    Lionel

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Don't use a job for that.... use a transformation... table input with your query with a hop to a set variables step (with scope set to root job e.g.). Execute transformation in a job and afterwards in that job you can use the variable.

    Regards,
    Sven

  3. #3

    Default

    Thank you very much, Sboden, for your for your very quick answer.
    I follow your instructions and it works perfectly now !!!

    Lionel

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.