For input string ERROR

Anonymous — Thu, 26 Jan 2017 19:53:19 GMT

Hello,

Talend can't see rows and appear this error
For input string: "N01111"
Can anybody help me to solve this problem

Re: For input string ERROR

Anonymous — Thu, 26 Jan 2017 21:18:11 GMT

The problem is quite clear, you are trying to read a string typed value as number. Please check the schema and take care all columns are at the right position. You use the build-in Excel component and this component expects you have to map all columns to a schema column regardless if you need it or not. It order of the columns must be exactly the same as the order of the columns in your file (starting with the start column index of course).

BTW: you have posted your question in the Big Data section? Excel are not really Big Data or not?

topic For input string ERROR in Talend Studio

For input string ERROR

Re: For input string ERROR