Problem loading Data

[dlarrain]

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).

[Anil_Babu_Samineni · Accepted solution]

try as Text(Code) as Code

[dlarrain]

Perfect, thank you very much.

[Anil_Babu_Samineni]

Glad, Please close this thread putting flag correct answer.