Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Table input step argument substitution

  1. #1

    Default Table input step argument substitution [SOLVED]

    Hi all,

    I'm trying to pass some parameters from an xaction to a kettle transformation, and then execute a sql query.

    I've been able to do it with simple arguments, like for example:

    select * from clients where country=?

    What I want to do now is pass a (variable) list of values, to execute a query like:

    select * from clients where country in (...)

    , where ... can be one or any countries. But after trying a few things I can't get it working. Is this possible? What is the proper syntax?

    Any help is much appreciated. Thanks.


    Kettle - Spoon version 3.2.0
    Last edited by fnavarro; 07-28-2010 at 07:05 AM.

  2. #2

    Default

    I found out how to achieve this: with variables. So I ended up having a Kettle job which contains too transformations, one for setting the variables received from the xaction, and another one to execute the query.

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.