Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pass a variable to table input script

  1. #1
    Join Date
    Jun 2017
    Posts
    25

    Default Pass a variable to table input script

    HI, I want to get a data from db with condition where the condition is passed from a text file that act as controller for the script to run.
    attach below are the screenshot for my transformation and steps:
    Name:  Capture1.jpg
Views: 460
Size:  7.3 KB
    transformation: get data from text file which will be the condition for the table input script, get variable step to set variable.

    Name:  Capture2.jpg
Views: 805
Size:  27.1 KB
    script for my table input

    Name:  Capture3.PNG
Views: 505
Size:  11.0 KB
    text file input with data that will control table input script

    Name:  Capture4.PNG
Views: 464
Size:  8.3 KB
    get variable setting

    I can run this transformation, but there is no table input and text file output produce. see below:
    Name:  Capture.jpg
Views: 454
Size:  8.2 KB

    what did i do wrong in this transformation?

    Regards,
    Rayzal

  2. #2
    Join Date
    Aug 2016
    Posts
    142

    Default

    I think USER_NAME= '?' needs to be changed to USER_NAME='${CF}'

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    You don't need your Get Variables if you are trying to get a column from a prior steps.

    Please take the time to learn about variables in PDI before you try to use them. Our language is finicky but distinct (Tranformation *Steps*, Job *Entries*) making it really clear what things are being talked about.

    Next, you won't need the ' around the ? in your Table Input (" WHERE USER_NAME = ? ") You will only be allowed ONE column coming into the table input step. IF you have more than one column, you will get an error.

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.