Do not differentiate between 0000 and 000000

[Mohammad_Adnan_Ansari]

One of the character columns in my database has two values: 0000 and 000000. These are two different value but when I load in Qlik Sense it coverts the other to 0000 as well and now I have two duplicates instead of 4 digit and 6 digit values. Please let me know how to overcome this issue. 

Same is the case with '01', '0001', and '000001'. Qlik Sense coverts all to '01'.

[Kashyap_R · Accepted solution]

Hi

while loading convert it to text and load as below

Load

Text(Column) as Col

from src;

Hope this helps

Thanks