topic Re: tconverttype component problem in Talend Studio

tconverttype component problem

RAJ6 — Fri, 01 Dec 2017 07:27:18 GMT

Hi Folks,

I have 75 rows are there in my excel.

In my excel have reject records. so I fixed all the columns datatype are string for metadata

Then I used tconverttype component for string to double.

I have tried but two records missing.

The tconverttype component not convert string to double properly.

is there any other way to solve this issue. Please kindly share your information.

Re: tconverttype component problem

Anonymous — Mon, 04 Dec 2017 06:33:16 GMT

Hello,

What does the missing two records look like?

Would you mind posting your job design screenshots on forum so that we can check it to see if it is a bug for tConvertType component.

Best regards

Sabrina

Re: tconverttype component problem

Anonymous — Thu, 29 Nov 2018 18:35:46 GMT

SUppose our data has commas in between then it fails to read it as double. sometimes even the negative sign.
Eg: -32,987,987
This value wont be read by tconverttype.
is there any bug? or can we avoid this?

Thanx

Re: tconverttype component problem

Anonymous — Fri, 30 Nov 2018 04:53:20 GMT

@Aishwarya,

You will have to clean your data by removing comma before applying the type conversion. Comma is added to a number for readability purpose but it will create problem while type conversions.

Could you please use java replace command to remove all comma with empty string and then try to convert the string?

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: tconverttype component problem

manodwhb — Fri, 30 Nov 2018 05:36:10 GMT

@Aishwarya,Yes as suggested by @nthampi, first remove the special charters,if you have by using removeall function in java,that you can use in tJavarow or tMap,based on the way and then covert from sting to double it will work.

Re: tconverttype component problem

Anonymous — Sun, 02 Dec 2018 19:06:44 GMT

Can you tell me the formula to remove all comas? //D removes other characters like negative sign and percentage

Re: tconverttype component problem

Anonymous — Mon, 03 Dec 2018 03:50:59 GMT

@Aishwarya,

Please use the below function in tmap to convert comma to empty string.

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

If the answer has helped you to resolve the issue, could you please mark the topic as closed? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi