Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adnanans
Contributor
Contributor

Do not differentiate between 0000 and 000000

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'.

 

1 Solution

Accepted Solutions
kashyap
Partner
Partner

Hi

while loading convert it to text and load as below

Load

Text(Column) as Col

from src;

Hope this helps

Thanks

View solution in original post

1 Reply
kashyap
Partner
Partner

Hi

while loading convert it to text and load as below

Load

Text(Column) as Col

from src;

Hope this helps

Thanks

View solution in original post