tconverttype component problem

[RAJ6]

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. 

[Anonymous]

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

[Anonymous]

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

[Anonymous]

@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

[manodwhb]

@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.

[Anonymous]

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

[Anonymous]

@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