Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sai_katare
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)
1 Reply
rwunderlich
MVP & Luminary
MVP & Luminary

Text(PartNo) as PartNo

-Rob