Need help figuring why tSortRow is not parsing this string.

[Anonymous]

Is there something wrong with the way I transform the excel doc to a csv? 

What are some common mistakes for not parsing? 

Couldn't parse value for column 'movieID' in 'row1', value is 'movieID,title,releaseYear,directorID'. Details: java.lang.NumberFormatException: For input string: "movieID,title,releaseYear,directorID"

[Anonymous · Accepted solution]

@lukeeids  your data is coming other than the format what you have specified in the Schema

Since i will suggest you to write it to tLogRow by specifying the string data type and see the data how are you getting.

or still if its not resolved. Share the screenshot job flow and data types of source and target.

Thanks,

Prabuj

[nfz11]

It looks like you are parsing the header row which probably has a different delimiter than the data.  Per the error message, it is trying to parse whole header string as an int because your first column, movieID, is defined as an int.  I think there is an option in the tFileInputDelimited to ignore the header row.  I don't think your problem has anything to do with the tSortRow.

[Anonymous]

Hi,

   I believe you have set the movieID as an integer but your header is also trying to get into the target data system. So you need to ignore the first row 'movieID,title,releaseYear,directorID' since its not integer.

   Add the header value as 1 in the tFileInputExcel as shown below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Thanks! I used all strings and converted to all strings and it seemed to work.

However, when I try to convert to integers it fails to parse. 

This looks like integer to integer

OR

String to integer.

I feel as if I am missing some basic knowledge for how to read specific data types from the .csv files...

[Anonymous]

Hi,

   Please use tConvertType component if you want to do any changes in the data type.

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/GDoeGgb~qKpyQ_84gB37WQ

   This will help you to easily maneuver between different data types.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂