floating number input is read as int

Question

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

df · Answer

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

ChrisTX · Answer

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

Chris