help in column value

[ali_hijazi]

Hello

we have a table in SAP for Warehouses

the issue is that we have 2 codes 1, and 01

when I read this table in Qlik 1 and 01 are considered the same

(check below)

my load statement is as follows:

Load WhsCode, WhsName

or

Load text(WhsCode) as WhsCode, WhsName....

but I get the following:

How can I make Qlik differentiate between the two codes?

[Gysbert_Wassenaar · Accepted solution]

You need to explicitly convert the values to text directly in the load:

LOAD

     Text(WhsCode) as WhsCode,

     ...other fields...

     ;

SQL SELECT * FROM ...sap_table... ;

[Gysbert_Wassenaar]

Can you share the parts of the script that loads this field?