Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error: For input string: "31/01/99"

Hi,
I use Talend for Big Data, in executing my job i receive too errors.
`For input string: "31/01/99"
Data truncation: Data too long for column 'Company' at row 33
`
In input file ecxel the format of data is "dd/MM/yyy"
When i chose this format or "dd-MM-yyyy" in input and output schema i receive this error.
My output file it is a table MySQL.
About the second error, the type chosen is string.
I'm sure that you can help me.
Thank you
Labels (2)
1 Reply
Anonymous
Not applicable
Author

You are intending to write a date value in a column called "Company" ? I would say you read the wrong excel column or write into the wrong db column. Take care the Talend excel components depends on reading the data at a specific column and need to read all following columns until the last column you are need.