US and Worldwide: +1 (866) 660-7555
Results 1 to 5 of 5

Thread: Validating Excel sheet

  1. #1

    Default Validating Excel sheet

    Hello,

    I just start to use Kettle and I have a problem with the Data Validator object, when it finds the first error the job stops and I want the job continues until Excel sheet is readen totally and insert valid rows in a oracle table, how can I do this??

    Thanks in advance
    BR

  2. #2
    Join Date
    Feb 2009
    Posts
    296

    Default

    you need to exit hops from that data validator - one for the good rows, one for the bad ones.
    Fabian,
    doing ETL with his hands bound on his back

  3. #3

    Default

    ok, how can I do for the bad ones?? the type of the hop is different but I don´t know how can i change??

    thanks in advance

  4. #4

    Default

    Hi,

    You have to set the "error handling" on validator step :


    http://wiki.pentaho.com/display/EAI/Data+Validator


    http://wiki.pentaho.com/display/EAI/...pErrorHandling

    Samatar
    Samatar

  5. #5

    Default

    ok, it works

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •