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.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables