Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dlarrain
Contributor
Contributor

Problem loading Data

I have a problem loading a company master table containing the company code and company name.
The problem is that company1 has code 001 and company2 has code 1, loading the table in qlikview generates a table where both companies have code 001.
the company code is defined in SQL Server as Varchar (10).image.png

 

1 Solution

Accepted Solutions
Anil_Babu_Samineni

try as Text(Code) as Code

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

3 Replies
Anil_Babu_Samineni

try as Text(Code) as Code

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
dlarrain
Contributor
Contributor
Author

Perfect, thank you very much.

Anil_Babu_Samineni

Glad, Please close this thread putting flag correct answer.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful