https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771273#M717724 <P>I have a problem loading a company master table containing the company code and company name.<BR />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.<BR />the company code is defined in SQL Server as Varchar (10).<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 598px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46296i6F4F01E6483B28E2/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>&nbsp;</P> Wed, 30 Dec 2020 20:17:43 GMT dlarrain 2020-12-30T20:17:43Z https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771273#M717724 <P>I have a problem loading a company master table containing the company code and company name.<BR />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.<BR />the company code is defined in SQL Server as Varchar (10).<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 598px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46296i6F4F01E6483B28E2/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>&nbsp;</P> Wed, 30 Dec 2020 20:17:43 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771273#M717724 dlarrain 2020-12-30T20:17:43Z https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771276#M717725 <P>try as <STRONG>Text(Code) as Code</STRONG></P> Wed, 30 Dec 2020 20:36:35 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771276#M717725 Anil_Babu_Samineni 2020-12-30T20:36:35Z https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771279#M717726 <P>Perfect, thank you very much.</P> Wed, 30 Dec 2020 20:44:43 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771279#M717726 dlarrain 2020-12-30T20:44:43Z https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771285#M717727 <P>Glad, Please close this thread putting flag correct answer.</P> Wed, 30 Dec 2020 21:14:26 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Data/m-p/1771285#M717727 Anil_Babu_Samineni 2020-12-30T21:14:26Z