Read two csv files in Talend OS

I am trying to read two csv files in Talend OS, i have inferred the metadata schema from the same CSV file, and set the first row appear as header, and comma (,) as delimiter in my code:
tMap will read the csv file, do a lookup on another csv file, and generate two output files passed and reject records.
But i am getting the error like this when i run the job:
Couldn't parse value for column 'Material_ID' in 'row1', value is '6459, Machine,6'. Details: java.lang.NumberFormatException: For input string: "6459, Machine,6"

I think it is considering entire row as one string for "Product_ID" column. I have set the delimiter and row separator correctly then why it is happening.
No rows is going from the first tInputFileDelimited due to above error.
Any suggestion to solve this?

Tagged:
Sign In or Register to comment.