Validating Excel sheet

[jatoru]

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

[fabianS]

you need to exit hops from that data validator - one for the good rows, one for the bad ones.

[jatoru]

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

[shassan2]

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/.09+Transformation+Steps#.09TransformationSteps-StepErrorHandling

Samatar

[jatoru]

ok, it works

Thanks