SQL server stored procedure column value is changing from 401 to 401.0 when loaded on to QLIKVIEW

[#1]

hello ,

Sql server stored procedure is called from qlikview report and specifically one value of a column is getting converted from 401 to 401.0 during load execution ..

tried to CAST all the values to a string of that column  in stored procedure , but still it is coming as 401.0 , wanted to come as 401

confused , why such thing is happening.

can somebody throw light on this , please

Many Thanks

Donesh

[#2]

Hi Jonathan ,

it worked , spot on . Many Thanks

[sasiparupudi1]

LOAD if (IsNum(ID),round(ID),Text(ID))) As ID, *;

     SQL Exec <stored proc>;

[#4]

hi Sasidhar,

one thing , in preceding load for stored procedure , you have to consider all fields separately , * is not working giving ODBC read failed error.

Cheers

Donesh

[sasiparupudi1 · Accepted solution]

Cool, please close this thread by marking the correct answer