Text loading as numbers

[#1]

Hi,

I have a table in access database with column cameraname and this column contains character(text) adat. When I am loading this table the character data is loading as numbers. can anyone let me know please what is this strange behaviour.

Thanks.

[dirk_konings]

Could it be a DUAL field in Db ?

You show a text but in database you remember the corresponding number?

D.

[#3]

no there is only column with column name as 'cameranames'. In the database the column contains names of the cameras but when I am loading it is showing digits(numbers) instead of names. Any solution?

[dirk_konings]

Please add some printscreens of your table in Access and also the field definitions in Access.

D.

[Peter_Cammaert]

In a listbox called 'cameranames', numbers will appear at the start. Are you sure there aren't any real names at the end of the list? It could be that the database field contains not only real cameranames, but also some (historical) numbers.

[#6]

I am sure there are no numbers in database table. Why it is showing numbers?

EDIT: moreover when I copied the table column to excel and when reloading the data from excel I can able to see cameranames. But when I amloading directly from database it is showing numbers. Is there any reason for this behaviour?

[Bill_Britt]

Check this out in 11.20 SR 5 release notes.

Bug: 65030 Mixed Values with values like 1E4 are mismatched

When loading text fields QlikView has always tried to interpret numeric values and load them as numeric, not text. Due to two different bugs the behavior of QlikView interpretation of exponential numbers, nnnEn or nnnDn, has changed between releases. The safest way to make sure you get the interpretation you like has always been to cast the specific fields to the right type in the script.

For customers with many old scripts affected by the behavior change, it has been decided to implement a solution which allows a small degree of control of how QlikView will interpret text fields at script level. A script variable 'ExponentNumberNotation' has been introduced. It can be assigned:

0 meaning neither 1.23E6 nor 1.23D6 is interpreted as an exponential number

1 meaning 1.23E6 but not 1.23D6 is interpreted as an exponential number

2 meaning both 1.23E6 and 1.23D6 are interpreted as an exponential number

If not assigned a value in the script, 1 will be the default value.

[#8]

Thanks. How to cast this?

[Peter_Cammaert]

SET ExponentNumberNotation = 0;

at the beginning of your script.

[#10]

I used this . Still showing same numbers. Please can sort this as because of this I stucked in middle to produce the complete chart.

[Peter_Cammaert]

Please post your document (without section access).

Otherwise we can only continue making wild guesses, and you'll be stuck in the middle for I-don't-know-how-much-longer. Thanks.