topic help in column value in QlikView

help in column value

ali_hijazi — Wed, 14 Dec 2016 11:23:41 GMT

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

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

but I get the following:

How can I make Qlik differentiate between the two codes?

Gysbert_Wassenaar — Wed, 14 Dec 2016 11:32:18 GMT

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 — Wed, 14 Dec 2016 12:09:23 GMT

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