Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load field with ODBC Drivers

Hello,

When i load the field NOCLI Customer Number (Alphanuméric Value) from Db2. QV automaticaly Add Zeros Before.

Db2 : Field Value '000001' -> QV Field Value ='000001'

Db2 : Field Value '1bbbbb' -> QV Field Value ='000001' (Where b=blanck)

The 2 Db2 Field are différent but in QV there are equal = Problem

Is there any way that QV don't add the Zeros Before. (Force the fied to load in AlphaNuméric Value) ?

Thanks

10 Replies
Not applicable
Author

Ok this is a solution. I just have to always think to convert all the key field for good mapping

Domage there is no alternative

Thanks