SQL error converting data type varchat to float

mikefromoke — Fri, 08 Jul 2016 10:50:11 GMT

Hi @all,

while trying a simple data load from an sql-tableview i get this error from qv:

anyone an idea how to get rid of this message? i'm really no sql-expert, but there might be a way to handle the datasets , maybe with a "convert" or something like that..

any sql-experts?

regards

Re: SQL error converting data type varchat to float

PrashantSangle — Fri, 08 Jul 2016 10:53:15 GMT

Hi,

It is query issue.

Is the above query run properly in your sql editor

If your using SQL server db then look convert() and cast() might help you.

Regards,

Prashant

topic Re: SQL error converting data type varchat to float in QlikView

SQL error converting data type varchat to float

Re: SQL error converting data type varchat to float