Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Update table data with value in variable

  1. #1
    Join Date
    Jan 2014
    Posts
    7

    Default Update table data with value in variable

    Hi Guys!!

    I am new to Kettle and getting an issue while passing the value of variable in Execute SQL Script task. Below is the image of the kettle I am trying:

    Name:  1.jpg
Views: 40
Size:  15.3 KB

    In "Set variable", I am assigning the output of "Table Input 2" to variable CURRENTTS and then based on this ${CURRENTTS} value I am able to get the data from "Table input" step and then the data is getting populated into other table using "Table Output".
    Now after "Table output" I want to update the value of variable ${CURRENTTS} into a table for which I used "Get variable" & "Execute SQL Script" but at this point ${CURRENTTS} becomes NULL.

    Please suggest me ways to update the variable value in the table.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    You cannot set and get variables within the same transformation.
    In one transformation you set the variables, in a second transformation you retrieve them.
    Both transformations have to be within the same job.
    -- Mick --

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.