So, I have an .txt file that contains data separated by "|".
I have this file:
And this job:
And this schema:
So, the problem is that I can't get the field "CNPJ" because talend throws this "for input string" error. If I change the schema from "int" to "string" it works. But I want it as integer. So why it isn't working? The first fields are integers too and they are working properly.
What I tried:
- I have searched throws this page and the forum, but didn't find a similar problem.
- I tried to change the type of the file from ".txt" to ".csv".
- I checked the field separator and it is right ("|").
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema