Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Need Help Getting Original Record After Parsing Error

  1. #1
    Join Date
    May 2013
    Posts
    12

    Question Need Help Getting Original Record After Parsing Error

    Hello,

    I have a transformation with a CSV File Input step that writes records that have errors to a file in a CSV File Output step. The problem is that I only get a partial record written to the file when there is an error and I need the original record. I've tried using a RowListener on the input step but only get the correctly formatted records and a RowListener on the output step only gets the incomplete record where the error occurred. Is there a way to get the complete record where the error occurred?

    Thanks in advance!

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Why don't you attach a transformation with a single input row that shows your problem?
    So long, and thanks for all the fish.

  3. #3
    Join Date
    May 2013
    Posts
    12

    Default

    I've attached the ktr file, an example row that fails is this:

    2,Jane,Doe,89165,Las Vegas,1970/02/02,Second,a,NV,Nevada

    Thanks for the help.
    Attached Files Attached Files

  4. #4
    Join Date
    May 2013
    Posts
    12

    Default

    Or is there a way with the api that I can get all the rows read from the file in the CSV Input File step so I can compare later with rows I get form a RowListener to get the original record?

  5. #5
    Join Date
    May 2013
    Posts
    12

    Default

    Looks like this happens with the Get data from XML step as well. I'm guessing it does with all the steps. Surely there is a way to get the original record so I can log it to a database? Any suggestions?

    Thanks!

  6. #6
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Sorry, can't help you with embedded Kettle
    So long, and thanks for all the fish.

Tags for this Thread

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.