Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Simple Evaluation Doubt.. Need Help

  1. #1
    Join Date
    Nov 2014
    Posts
    13

    Default Simple Evaluation Doubt.. Need Help

    Hello there.,

    i'm trying to execute a job where im trying to get the value from the execute sql and use it with the simple evaluation.
    Plz find the attachment with this
    Attached Images Attached Images  

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

    Default

    Use a Transformation instead of the SQL job entry.
    In that transformation use a Table Input step followed by a Set Variables step.
    Reason: Table Input is the only way to access a query result.
    So long, and thanks for all the fish.

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.