Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Approach To Merge The Result

  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Question Approach To Merge The Result

    I'm looking for an approach to merge the result of a SQL query and a corresponding separator string to a string.


    I have the query „select emailadress from tab1“ ( with for example three records as a result) and the separator string “, “. I need the result string “abc@gmx.de, def@gmx.de, ghi@gmx.de“.


    Can any one give an idea for an approach me? The email addresses are only an obvious example.


    I am using Kettle 4.4.0 stable.

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

    Default

    The step you are looking for is named "Group By".
    So long, and thanks for all the fish.

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.