topic Re: convert to INT Tmap fails in Talend Studio

convert to INT Tmap fails

daez — Mon, 03 Dec 2018 14:45:00 GMT

Hello,

I have an excel input file which has number types such as : 45,34 or 1916.

I have : tfileinput >>>>> tmap >>>>>> tfileoutput. So in the schema i put the column type "integer " in the input/tmap/output.

I want my output of this column in integer. Its all working good except for 1000+ number, they are not written. Why? 999,99 is working but 1111 is not. In the console I have this kind of error, in red : " For input string: "1,916"? But in my input I dont have any "," except for the decimal... Help?

Re: convert to INT Tmap fails

Anonymous — Mon, 03 Dec 2018 15:06:45 GMT

Hi,

Could you please add a replace all function to remove all commas before passing to the tconverttype?

Its working fine when the data is reaching in cleansed numerical format. Please see the screenshot below where input is string but output is integer.

Warm Regards,

Nikhil Thampi

Re: convert to INT Tmap fails

daez — Mon, 03 Dec 2018 15:26:57 GMT

Hello @nthampi, thanks for your time !

Actually, I have to keep the comma ! Maybe I should explain myself better.

My input column looks like :

And format is " number " on my excel sheet.

I want it in my input as number or integer what ever. But from now on, in my output I only have 334 & 78. I just tried "TconvertType" components but have the same error : " For input string: "1,916"

Re: convert to INT Tmap fails

manodwhb — Tue, 04 Dec 2018 04:18:16 GMT

@daez,since i suggest you to read first that column as string and remove that "," and the convert sting to integer.

row1.col.replace(',','')

Re: convert to INT Tmap fails

Anonymous — Tue, 04 Dec 2018 04:48:08 GMT

@daez,

Here you go! You can use below function to clear all the commas. Please refer both input and out in below screen shots and component details.

row1.input.replaceAll(",","")

Job flow

tMap replace

tConvertType

yConvertType schema

Could you please mark the topic as resolved since your query is answered? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: convert to INT Tmap fails

manodwhb — Tue, 04 Dec 2018 04:52:49 GMT

@daez,i sugget with @nthampi replay,but you no need to use tConvertype,instead of that in same tmap you can convert form sting to integer.

Integer.parseInt(row1.Coll)

Re: convert to INT Tmap fails

Anonymous — Tue, 04 Dec 2018 04:57:08 GMT

I agree with @manodwhb.

I added tConvertType to give a better graphical representation 🙂

Warm Regards,

Nikhil Thampi

Re: convert to INT Tmap fails

manodwhb — Thu, 13 Dec 2018 05:19:43 GMT

@daez,still do you have this issue?