topic geting nell values in table in QlikView https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275086#M102724 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>my source data is like this,</P><P></P><P>col1</P><P>-----</P><P>5674</P><P>a3423</P><P>5674</P><P>a234</P><P></P><P>when i am loading data in ms sql,i am geting </P><P>like this..</P><P></P><P>col1</P><P>---</P><P>5674</P><P>null</P><P>5674</P><P>null</P><P></P><P>i need to get exact data from source?for that wht is a datatype need to choose?even i choose nchar or nvarchar i am get null values,pls let me know any one..</P><P></P><P></P><P>Rgds</P></BODY></HTML> Tue, 12 Jul 2011 12:22:49 GMT 2011-07-12T12:22:49Z geting nell values in table https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275086#M102724 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>my source data is like this,</P><P></P><P>col1</P><P>-----</P><P>5674</P><P>a3423</P><P>5674</P><P>a234</P><P></P><P>when i am loading data in ms sql,i am geting </P><P>like this..</P><P></P><P>col1</P><P>---</P><P>5674</P><P>null</P><P>5674</P><P>null</P><P></P><P>i need to get exact data from source?for that wht is a datatype need to choose?even i choose nchar or nvarchar i am get null values,pls let me know any one..</P><P></P><P></P><P>Rgds</P></BODY></HTML> Tue, 12 Jul 2011 12:22:49 GMT https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275086#M102724 2011-07-12T12:22:49Z geting nell values in table https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275087#M102725 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>In the load try text(col1).</P><P></P><P>Regards.</P></BODY></HTML> Tue, 12 Jul 2011 12:28:35 GMT https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275087#M102725 spividori 2011-07-12T12:28:35Z geting nell values in table https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275088#M102726 <HTML><HEAD></HEAD><BODY><P>still unable to load..</P><P></P><P>pls help any one?</P></BODY></HTML> Wed, 13 Jul 2011 05:37:12 GMT https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275088#M102726 2011-07-13T05:37:12Z geting nell values in table https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275089#M102727 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>In the load try keepchar ( Sex,'1234567890' ) </P></BODY></HTML> Wed, 13 Jul 2011 05:52:37 GMT https://community.qlik.com/t5/QlikView/geting-nell-values-in-table/m-p/275089#M102727 perumal_41 2011-07-13T05:52:37Z