AnsweredAssumed Answered

How to divert data without errors to a table

Question asked by Ashraf Nazar on Dec 6, 2017
Latest reply on Dec 7, 2017 by Maria Carina Roldan

Hi,

 

I am a beginner using PDI and I have ran into some problems when loading data into a table.

 

The CSV file I am reading from has a few fields where there are different data types. This is giving me trouble when getting this into a table.

 

Screen Shot 2017-12-06 at 11.49.13.png

 

The error message I am getting is

2017/12/06 11:41:54 - Table output.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Error initializing step [Table output]

2017/12/06 11:41:54 - Table output.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : java.lang.NumberFormatException: For input string: ""

2017/12/06 11:41:54 - Table output.0 - at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

2017/12/06 11:41:54 - Table output.0 - at java.lang.Integer.parseInt(Integer.java:592)

2017/12/06 11:41:54 - Table output.0 - at java.lang.Integer.parseInt(Integer.java:615)

2017/12/06 11:41:54 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:477)

2017/12/06 11:41:54 - Table output.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)

2017/12/06 11:41:54 - Table output.0 - at java.lang.Thread.run(Thread.java:745)

2017/12/06 11:41:54 - Transformation 1 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Step [Table output.0] failed to initialize!

 

I would like to keep all the data which is of the data type specified and send all the others to a log/text file.

 

I would appreciate any assistance in this matter.

Outcomes