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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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