Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Concate Two fields

  1. #1
    Join Date
    Jun 2007
    Posts
    138

    Default Concate Two fields

    Hi..

    I want to Concate 3 fields.All are varchar2(database-Oracle).
    Which component can serve me?rather then java Script..?

    I ll need some level of flexibility even..Like if field coming In Input is Null then it should replace it with one space.(one white Character)

    Java Script is the last option Which wud use...I think there is some component..(kettle 2.4)
    Regards,
    kedar.mehta@tcs.com ,
    Tata consultancies Ltd

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

    Default

    You can use calculator todo A || B... but the flexibility is limited there... Javascript it is

    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.