Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Plugin to use a set variable or other way

  1. #1
    Join Date
    Jun 2012
    Posts
    13

    Default Plugin to use a set variable or other way

    Hello. I keep trying to use a set variable in the same transformation.

    I already read that this is not possible, but i need to handle the query how i want according the filters selected.

    This is possible to do in a kettle plugin?

    I've asked in another post, but take the opportunity to ask again .... is there any way to do execute a string query?...
    Something as simple as this...

    var string = "select field from table where";
    if (true) string += " any condition";
    else string += " other condition";

    execute string...

    In cde, in spoon, in xaction result set(legacy datasource)... whatever, but i need it.

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

    Default

    Quote Originally Posted by beldario View Post
    execute string...
    In PDI you would use the "Execute row SQL script" step for this.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Jun 2012
    Posts
    13

    Default

    Quote Originally Posted by marabu View Post
    In PDI you would use the "Execute row SQL script" step for this.
    When i create a var in javascript step with the query string and execute it in "Execute row SQL script" no show any result. And if i put a name field in "Field to contain Read stats" returns a 0 int.

    Is there any way to show the result of "Execute row SQL script"?

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.