floating number input is read as int

[df]

Hello,

i have an input tool loading data from the database. There are some columns with float data type.
But in Alteryx it is always "0" instead of the correct number.

We tried it on an other computer with alteryx and there it does work:

does not work on other computer:

How could we fix this?

Best,
David

[ChrisTX]

Do both computers have the same ODBC drivers and versions?  If each machine has its own DSN, compare them using a text editor.

Chris

[df]

Hi @ChrisTX 

Thanks for you answer. The ODBC drivers is the same.

i found a solution now.
in the original sql statment we had:
SELECT [schemaname].[tabelname].* FROM [schemaname].[tabelname]

if we remove [schemaname].[tabelname] from the select then it does work.
on the other computer we just had the "SELECT * FROM"

Best,
David