Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Concatenation of Strings

  1. #1
    lakksv Guest

    Default Concatenation of Strings

    Can anyone suggest how to concatenate string in Pentaho Data Integration (PDI).
    1. Sequence number to be generated
    2. Prefixed with "AD" to the generated sequence number.

  2. #2
    Join Date
    Nov 1999


    First generate rows with the Generate Rows step.
    Then use an Add Sequence step to generate an integer value called "nr".
    Then convert this field to a String using mask 0000 (or something longer) using metadata tab of the Select Values step.
    Then Add a constant String value called "AD" containing value AD.
    Then use a calculator step to calculate String field "result" with formula A+B, specify fields AD and nr.

  3. #3
    Join Date
    Apr 2008


    You can find examples in your installation directory:


Tags for this Thread

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.