Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: how to concatenate more than two fields in pentaho 4.2 version

  1. #1
    Join Date
    Jan 2017
    Posts
    12

    Default how to concatenate more than two fields in pentaho 4.2 version

    how to concatenate more than two fields in pentaho 4.2 version. Let me know

  2. #2
    Join Date
    Jun 2016
    Posts
    107

    Default

    Hi Narayana,

    We don't have Concat Field step in Pdi 4.2 version but it is available in latest version.

    You can use Calculator step. Below snap shot is useful to you.

    Name:  2.jpg
Views: 110
Size:  21.0 KB

    Thanks,
    Janu
    Last edited by Jahnavi; 11-10-2017 at 05:40 AM.

  3. #3
    Join Date
    Nov 2009
    Posts
    688

    Default

    You can use all kind of scripting method. For example
    With formula: [field1]&[field2]&[field3]&[field4]
    With User Defined Java Expression: field1 + field2 + field3 + field4

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

    Default

    The title of the thread makes me wonder why someone would ask about concatenation of more than two fields if he already knows how to concatenate two fields.

    Just for completeness: Group-By has a concatenate function usable after proper normalization - an approach that's open for injection, in case someone is looking for a generic solution.
    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.