Import Excel decimal to MySQL

[Anonymous]

Hello,

I would like import data from excel file to Mysql Database.
I don't success to import number with decimal because excel format is xxxx,xx
Mysql need a number format with xxxx.xx
For the moment i declare Excel number as a bigDecimal 18,3 and in Mysql DECIMAL 18,3

I begin with talent and i would like to know the best practice.
I tried many conversions in TMap without success.
It's the right way to declare number as decimal or declare as a string ?

Thanks for your help

[Anonymous · Accepted solution]

Hi,

   Could you please try the decimal separator operator in advanced section of excel input component?

Make sure that you are changing the thousand separator operator to something different or empty string.

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

[Anonymous]

The problem was comming of decimal separator manage.
Thanks that work