https://community.qlik.com/t5/Official-Support-Articles/MSSQL-Dynamic-Data-Type-Issue-for-Float-Datatype/ta-p/2151350 <DIV class="talend-tkb-migrated-content">When we ingest the Data from MSSQL Database and update the MSSQL.xml file from Talend Project--&gt;General--&gt;Metadata Talend Type as follow, <P><SPAN style="background-color: #ffffff;">&lt;dbType type="FLOAT"&gt;</SPAN><BR /><SPAN style="background-color: #ffffff;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;talendType type="id_Float" default="true" /&gt;</SPAN></P> the output looks like below, which is we desired.<BR />348|39.2<BR />349|15.4<BR />350|8.8<BR />351|46.8<BR />352|47.2<BR />353|7.2<BR />354|25.2<BR />when using dynamic data mapping, it is unable to replicate the same result, and the data looks like below<BR />348 - 39.2<BR />349 - 15.400000000000006<BR />350 - 8.799999999999997<BR />351 - 46.8<BR />352 - 47.2<BR />353 - 7.200000000000003<BR />354 - 25.200000000000003<BR /><BR />workaround: is to use STR in the SQL queries and it will give desired result.<BR />"SELECT dbo.FLOAT_TEST.Col1,<BR />STR(dbo.FLOAT_TEST.Col2,6,1) strCol2<BR />FROM dbo.FLOAT_TEST"<BR /><A href="https://learn.microsoft.com/en-us/sql/t-sql/functions/str-transact-sql?view=sql-server-ver16" target="_blank">https://learn.microsoft.com/en-us/sql/t-sql/functions/str-transact-sql?view=sql-server-ver16</A></DIV> Fri, 09 Feb 2024 19:06:24 GMT TalendSolutionExpert 2024-02-09T19:06:24Z https://community.qlik.com/t5/Official-Support-Articles/MSSQL-Dynamic-Data-Type-Issue-for-Float-Datatype/ta-p/2151350 <DIV class="talend-tkb-migrated-content">When we ingest the Data from MSSQL Database and update the MSSQL.xml file from Talend Project--&gt;General--&gt;Metadata Talend Type as follow, <P><SPAN style="background-color: #ffffff;">&lt;dbType type="FLOAT"&gt;</SPAN><BR /><SPAN style="background-color: #ffffff;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;talendType type="id_Float" default="true" /&gt;</SPAN></P> the output looks like below, which is we desired.<BR />348|39.2<BR />349|15.4<BR />350|8.8<BR />351|46.8<BR />352|47.2<BR />353|7.2<BR />354|25.2<BR />when using dynamic data mapping, it is unable to replicate the same result, and the data looks like below<BR />348 - 39.2<BR />349 - 15.400000000000006<BR />350 - 8.799999999999997<BR />351 - 46.8<BR />352 - 47.2<BR />353 - 7.200000000000003<BR />354 - 25.200000000000003<BR /><BR />workaround: is to use STR in the SQL queries and it will give desired result.<BR />"SELECT dbo.FLOAT_TEST.Col1,<BR />STR(dbo.FLOAT_TEST.Col2,6,1) strCol2<BR />FROM dbo.FLOAT_TEST"<BR /><A href="https://learn.microsoft.com/en-us/sql/t-sql/functions/str-transact-sql?view=sql-server-ver16" target="_blank">https://learn.microsoft.com/en-us/sql/t-sql/functions/str-transact-sql?view=sql-server-ver16</A></DIV> Fri, 09 Feb 2024 19:06:24 GMT https://community.qlik.com/t5/Official-Support-Articles/MSSQL-Dynamic-Data-Type-Issue-for-Float-Datatype/ta-p/2151350 TalendSolutionExpert 2024-02-09T19:06:24Z