topic Re: Need help figuring why tSortRow is not parsing this string. in Talend Studio

Need help figuring why tSortRow is not parsing this string.

Anonymous — Thu, 13 Jun 2019 20:03:05 GMT

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"

Re: Need help figuring why tSortRow is not parsing this string.

Anonymous — Fri, 14 Jun 2019 05:10:49 GMT

@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

Re: Need help figuring why tSortRow is not parsing this string.

nfz11 — Fri, 14 Jun 2019 07:05:33 GMT

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.

Re: Need help figuring why tSortRow is not parsing this string.

Anonymous — Fri, 14 Jun 2019 14:39:13 GMT

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 🙂

Re: Need help figuring why tSortRow is not parsing this string.

Anonymous — Fri, 14 Jun 2019 17:29:15 GMT

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

String to integer.

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

Re: Need help figuring why tSortRow is not parsing this string.

Anonymous — Fri, 14 Jun 2019 17:31:37 GMT

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 🙂