Hi, I'm a newbie in Talend.. I found some issues when I'm trying to inserting data from Excel file into Talend. I try to insert Excel file using tFileInputExcel, but in the middle of the process Talend sent me an error message that stated "For Input String : xxxxxxxxxx". But Integer value with only 1 digit (Example: 2 or 5) can be inserted while the other value with 2 digits (Example: 10 or 14) can't be inserted.
Anybody ever experienced with this issue?
Thanks and Regards,
Actually the error came out when I used several combination from Excel column to make an aggregate count using tAggregateRow.
For Example : 4182168210
41821682 is my sample product code. Its data type is String.
10 is my quantity of my the product. The data type is Integer.
I've tried some ways just now, include try to remove 1-2 character from my product code (Ex: 41821682 to 418216) and the process accepted it. So I wonder when the combination happened my product code and quantity were blended together into Integer since max capacity of Integer is 2147483647 so if the amount is above the max value then it will error.
So there's several ways to prevent the error, whether change all data type into String for temporary and change it back to what it supposed to be when the combination is done, or change my quantity data type to Long (actually I haven't try this way yet so I dunno whether it'll works or not)
Thanks and regards,
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.