topic Import Excel decimal to MySQL in Talend Studio

Import Excel decimal to MySQL

Anonymous — Sat, 16 Nov 2024 03:49:41 GMT

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

Re: Import Excel decimal to MySQL

Anonymous — Mon, 16 Dec 2019 15:40:13 GMT

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

Re: Import Excel decimal to MySQL

Anonymous — Fri, 27 Dec 2019 12:59:58 GMT

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