Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Concatenation of Strings

  1. #1
    lakksv Guest

    Default Concatenation of Strings

    Hi,
    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
    Posts
    9,729

    Default

    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
    Posts
    1,771

    Default

    http://wiki.pentaho.com/display/EAI/...a+Script+Value

    http://wiki.pentaho.com/display/EAI/Calculator

    You can find examples in your installation directory:
    \data-integration\samples

    Mick

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.