I am loading an xlsx file into a redshift table, but I am seeing a fatal error and unable to load the data. Please help.
below is the run time error as seen in run console:
Exception in component tFileInputExcel_1
java.lang.NumberFormatException: Value out of range. Value:"42594" Radix:10
Java will not accept values to overflow. What does your input data look like? How did you set your data type in schema setting?
Hi Sabrina/ Talend Community,
I have attached a screenshot of how my input data looks like; Please look at the attachment, and I have set the data type according to the column data found in screenshot.