Exponential data issue

[#1]

Hi All,

Our data source is DB2 and we have created all the necessary qvd.

While validating the values, we realised that the a Primary Key which is 20 digit long is converted into exponential format while creating the QVD file because of which we are getting wrong values.

Is there any way by which we can get rid of this auto conversion of numeric data into exponential data while creating the qvd ?

eg:

Value in DB2: 10203040506070801020

Value in QVD; 102 e+17

[kaushiknsolanki]

HI,

Generally QlikView takes data as it is.

Kindly convert the field from number to text in DB and then try.

Regards,

Kaushik Solanki

[tresesco]

Try using text(), like:

Text(Value) as NumInText

then for any calculation on this field use like : =evaluate(NumInText)+10

[jagan]

Hi,

If you are not using this for calculation simply use

Data:

LOAD

*,

Text(Value) AS Value_Text

FROM DataSource;

Hope this help you.

Regards,

Jagan.