Qlik Community

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

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.



Labels (1)
  • Other

1 Solution

Accepted Solutions

Text(PartNo) as PartNo


View solution in original post

1 Reply

Text(PartNo) as PartNo