Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Add Filename to Result

  1. #1
    Join Date
    Dec 2012

    Default Add Filename to Result

    I'm fairly new to Kettle. I have a set of files that I want to parse using Fixed file input. The files have a naming convention and I need to get certain information from the filename to include in the results. I have checked Add filename to result but I'm not seeing the filename in my results in the next step. Is there something I am missing?

  2. #2
    Join Date
    Jun 2012


    "Add filename to result" does not add a field to your data row, but to the "File result" list.
    This list is available to capture all filenames engaged in your transformation.
    Either use a "Get File Names" step in a dedicated transformation, to convert filenames into an ordinary data row set,
    or replace your "Fixed file input" step with a "Text File Input" step, using the settings on the "Additional output fields" tab.

    Recommended reading: PDI Beginner's Guide (ISBN 978-1-847199-54-6)
    pdi-ce user (mostly 4.4)
    java 1.8.0_131 (OpenJDK)
    ubuntu 16.04 LTS (x86_64)
    timezone CET / CEST
    contemplative reading SSCCE
    sig updated 2017-10-20

  3. #3
    Join Date
    Dec 2012


    Thanks for the help. I switched over to the Text File Input and now I am getting what I need.

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 - 2017 Pentaho Corporation. All Rights Reserved.