Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Text File Input Error handling is not working

  1. #1
    Join Date
    Jan 2017
    Posts
    12

    Default Text File Input Error handling is not working

    I am getting some bad date format issues in Text File Input So i have created Error handling for bad records But i want that particular bad records in text file output log file. i am not getting any error logs in text file Out.

    Is it possible ?

  2. #2
    Join Date
    Sep 2011
    Posts
    152

    Default

    why dont you use filter step to filter out the bad formatted record and put it to another csv file.

  3. #3
    Join Date
    Jan 2017
    Posts
    12

    Default

    Actually i am reading the data in Text File Input (Ex: I have one "Date-Of-Birth" Field and date-format is like MM/DD/YY ) But some times "Date-Of-Birth" field data coming string values like MP , UP so at that time i am getting error in Text file Input level

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

    Default

    If you want total control over bad rows, don't rely on error handling in Text-File-Input, do your own conversion using Select-Values.
    So long, and thanks for all the fish.

  5. #5
    Join Date
    Jan 2017
    Posts
    12

    Default

    I am getting the error While reading the data in text file input So if i use select values also nothing use of me.

  6. #6
    Join Date
    Sep 2011
    Posts
    152

    Default

    is the date field you are trying to fetch is of "String" datatype, because it also contains some string value.

    and fetching as string there will be no error.

    you can post your sample data here.

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.