Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: string concatenated parameters in database join step

  1. #1

    Default string concatenated parameters in database join step

    Hi,

    i am working in kettle 2.5 version and want to know we can use string concatenated parameter in database join step like param1 = "aaaa"+","+"bbbb"(dynamic parameter)
    and in query select city,country from table1 where name not in (?);

    if this is not possible is there any other way to accomplish in same version.



    thanks,
    bhuvana

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Not with ? ... most databases do not support that.

    In Oracle you could write a function that transform your string into an array... that would work, but requires some extra Oracle thingies. Else using variables is an option, if 2.5 supported that in database join (not so sure about it).

    v3.1 supports it.

    Regards,
    Sven

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.