Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Log error if data is not in wrong format in excel file

  1. #1

    Default Log error if data is not in wrong format in excel file

    Hi All,
    I am using excel input step to read excel data. I want to log error if data in a particular column in excel file is of wrong format.
    For example, log error with line number, if string data in numerical field.
    I am using pentaho 7.1 ce.
    Please help.


    Thanks
    Ajinkya

  2. #2
    Join Date
    Aug 2016
    Posts
    290

    Default

    1) Add line number
    2) Try to convert String to int
    3) Direct error to log 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.