Unable to read text column properly from DB. '0041' and '41' are read as '41'.

[sai_katare]

Hi All,

I am unable to read a key column as expected from DB. 

When I check in DB, there are two records for part_numbers '41' and '0041'. But when I loaded the data into Qlikview I am getting two records tagged to part_number '41' ignoring the part_number with zeros.

Please suggest how to load both the records from DB.

Thanks in advance.

[rwunderlich · Accepted solution]

Text(PartNo) as PartNo

-Rob