US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: Add Filename to Result

  1. #1
    Join Date
    Dec 2012
    Posts
    2

    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
    Posts
    2,842

    Default

    "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-4.4.0-stable (with patches)
    java 1.7.0_51 (OpenJDK)
    ubuntu 13.10 (x86_64)
    timezone CET / CEST
    sig updated 2014-01-25

  3. #3
    Join Date
    Dec 2012
    Posts
    2

    Default

    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
  •