Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Adding a Constant value

  1. #1

    Default Adding a Constant value

    I looked at few threads but still confused on how this works.
    Here's what I'm trying to do.
    I have text file that contains values:
    A
    B
    C
    I have another text file that contains a single value:
    123
    I'm trying to combine both so that I have a text file with:
    123A
    123B
    123C
    I found this on one of the threads but it does not work:
    Basically you have the following steps in your example (as far as I know):
    1) Text File Input : read fields from a text file
    2) Calculator : add a constant value
    3) Select values: select the values you want
    4) Table Output: stores the data in a table

    Attached are the test files and transformation:
    text.ktr
    text1.txt
    text2.txt
    It's Friday so it's probably something simple that I'm overlooking.
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2009
    Posts
    321

    Default

    hi , here is a possible solution... this works, (I have change the files names, sorry ).
    Attached Files Attached Files

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.