Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Can you find out which input file a record came from?

  1. #1
    Join Date
    Nov 2007

    Default Can you find out which input file a record came from?

    We have a business requirement to put all rejected records in a single error file, tagged with the name of the input file.

    I can't see a way to do this currently. We have multiple layers of validation steps that all need to feed to the same place.

    We are using the File Input step with a wildcard to select multiple files from a directory. How do we pick up the name and record# of the particular input file where the bad record came from?


  2. #2
    Join Date
    May 2006


    Add the filename to the row as field. Text file input e.g. has an option for this "include filename in output".


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.