Qlikview does not respect code of item

[#1]

Good I gave, upon carrying out an information load process since a database, we find us with a case that modifies us values of a registration, doing it equal to another completely different one.

The column of the table is of the type Varchar (20) and the two registrations are the "0095342" and the" 095342" but in QlikView these they appear like "095342" being two completely different registrations.

As it can be indicated to QlikView that permit these values in the system since are many registrations that themselves us this passing this weakness.

[Oleg_Troyansky · Accepted solution]

Your post looks like an automated translation from another language... quite hard to understand...

From what I can see, you need to use function text() for your alphanumeric codes that contain numeric values:

load

...

text(ProductID) as ProductID,

...

It's important to use text() in the very first load from the original data file (Database, Excel, text, etc...)

This should solve your problem.