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.
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.
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 :-)
@Aishwarya,Yes as suggested by @nikhilthampi, 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.
Please use the below function in tmap to convert comma to empty string.
If the answer has helped you to resolve the issue, could you please mark the topic as closed? Kudos are also welcome :-)
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.