Different values after load from xlsx to MSSql

[Anonymous]

Hi all.

After loading data from xlsx to MSsql sum of column values get different from source.

MSSql sum(qty)MS Excel sumtMap

Do i something wrong?

[fdenis]

remove 16 and 3 who define lenth and Precision.

[Anonymous]

After remove lenght and precision

 SQL lost 0.001 from source

[fdenis]

for this type of troubles I prefer to use String into Talend so it's your db who make the conversion