topic Re: Data Quality: NumberFormatException: For input string: "" in Data Quality

Data Quality: NumberFormatException: For input string: ""

Anonymous — Sat, 16 Nov 2024 12:15:31 GMT

Hi,

I am new to the tool and I am trying to find out its functionality. A sample csv file is created as following:
Col1,col2
1,2
The columns have been imported as an Integer type.
When I run a Simple Analysis, I get the following error message:
2012-06-21 00:18:34,116 ERROR org.talend.dq.analysis.AnalysisExecutor - java.lang.NumberFormatException: For input string: ""
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at org.talend.dq.indicators.DelimitedFileIndicatorEvaluator.executeSqlQuery(Unknown Source)
at org.talend.dq.indicators.Evaluator.evaluateIndicators(Unknown Source)
at org.talend.dq.indicators.Evaluator.evaluateIndicators(Unknown Source)
at org.talend.dq.analysis.DelimitedFileAnalysisExecutor.runAnalysis(Unknown Source)
at org.talend.dq.analysis.AnalysisExecutor.execute(Unknown Source)
at org.talend.dq.analysis.AnalysisExecutorSelector.executeAnalysis(Unknown Source)
at org.talend.dataprofiler.core.ui.action.actions.AnalysisExecutorThread.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
eclipse.buildId=unknown
java.version=1.6.0_20
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_CA
Command-line arguments: -os win32 -ws win32 -arch x86
How can I fix this error?

Re: Data Quality: NumberFormatException: For input string: ""

karthikj18 — Thu, 21 Jun 2012 06:36:41 GMT

Hi
You can check that you have considered the first row as column name row in the source component. This error occurs when Talend identifies inserting string in the integer field.

Re: Data Quality: NumberFormatException: For input string: ""

Anonymous — Thu, 21 Jun 2012 07:44:55 GMT

Hi,
You might as well have the "Skip empty rows" option unchecked. This way the third row will be read as "","" resulting in an row with empty values which, in turn, will not pass integer validation.
Regards,
Arno

Re: Data Quality: NumberFormatException: For input string: ""

Anonymous — Thu, 21 Jun 2012 17:22:19 GMT

Thank you for your replies. Removing the caridge return at the end of the csv file solved the issue.

Re: Data Quality: NumberFormatException: For input string: ""

sbxr — Mon, 06 Aug 2018 13:03:29 GMT

@avdbrink wrote:
Hi,
You might as well have the "Skip empty rows" option unchecked. This way the third row will be read as "","" resulting in an row with empty values which, in turn, will not pass integer validation.
Regards,
Arno

where ..?