Problem loading record

[Anonymous]

Hi, i have a strange problem loading a table like this :

CODICE
10.507.1
15.207.1

when i put the fields CODICE on a sheet , i can only see the first value, the same happens changing the order of the data.

The other strange things is that the count of the record loaded return 2 !

Obviosly this data is just a part of a bigger table (23353 row)

Thank's

Luca C.

[#2]

One reason I know of that can cause this, is if QlikView thinks the two values are the same, it would then look like only one value once loaded. Perhaps the periods are fooling it. Try putting the value in single quotes.

[Anonymous]

Thank you Eugene,

for sure the periods cause the problem, unfortunatly this is the product code that my customer uses from many years.

I tryed the quote solution but without success.

The problem disappear if a put a character before the first number i.e.

A10.507.1

or if i replace the '.' with '_'.

but if i choose this solution i have to recode all table linked with the product table.

Sigh !

[rwunderlich · Accepted solution]

Try using the text() function when loading the field.

-Rob

[Anonymous]

Great!

Thank's Rob, it works fine !.

I've to modify the script but this is nothing compare to recode all the product.

Bye