Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

floating number input is read as int

df
8 - Asteroid

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:

funktioniert.PNG

 

does not work on other computer:

funktioniert nicht.PNG

 

How could we fix this?

Best,
David

2 REPLIES 2
ChrisTX
15 - Aurora

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
8 - Asteroid

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

Labels