https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277900#M53528 <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="After remove lenght and precision" style="width: 199px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M08O.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131637i0ED1145631D4CE6C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M08O.png" alt="0683p000009M08O.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">After remove lenght and precision</SPAN></SPAN></P> <P>&nbsp;SQL lost 0.001 from source</P> <P>&nbsp;</P> Thu, 13 Sep 2018 13:08:18 GMT Anonymous 2018-09-13T13:08:18Z https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277898#M53526 <P>Hi all.</P> <P>&nbsp;</P> <P>After loading data from xlsx to MSsql sum of column values get different from source.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MSSql sum(qty)" style="width: 197px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzVQ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152540iFB8B0C3804235395/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzVQ.png" alt="0683p000009LzVQ.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">MSSql sum(qty)</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MS Excel sum" style="width: 162px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzR0.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141580i8FCD2A286766968C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzR0.png" alt="0683p000009LzR0.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">MS Excel sum</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tMap" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzVV.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138502i9BA830001E425AEA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzVV.png" alt="0683p000009LzVV.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">tMap</SPAN></SPAN></P> <P>Do i something wrong?</P> Wed, 12 Sep 2018 08:30:37 GMT https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277898#M53526 Anonymous 2018-09-12T08:30:37Z https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277899#M53527 remove 16 and 3 who define lenth and Precision. Wed, 12 Sep 2018 09:34:46 GMT https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277899#M53527 fdenis 2018-09-12T09:34:46Z https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277900#M53528 <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="After remove lenght and precision" style="width: 199px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M08O.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131637i0ED1145631D4CE6C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M08O.png" alt="0683p000009M08O.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">After remove lenght and precision</SPAN></SPAN></P> <P>&nbsp;SQL lost 0.001 from source</P> <P>&nbsp;</P> Thu, 13 Sep 2018 13:08:18 GMT https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277900#M53528 Anonymous 2018-09-13T13:08:18Z https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277901#M53529 for this type of troubles I prefer to use String into Talend so it's your db who make the conversion Fri, 14 Sep 2018 07:45:43 GMT https://community.qlik.com/t5/Talend-Studio/Different-values-after-load-from-xlsx-to-MSSql/m-p/2277901#M53529 fdenis 2018-09-14T07:45:43Z