Unable to read text column properly from DB. '0041' and '41' are read as '41'.
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.