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
    Posts
    18

    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?

    Thanks,
    Geoffrey

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

    Default

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

    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.