topic Re: How to exclude certain values from a load in QlikView https://community.qlik.com/t5/QlikView/How-to-exclude-certain-values-from-a-load/m-p/423497#M1155305 <HTML><HEAD></HEAD><BODY><P>Thanks for this,</P><P>Regards,</P><P>Racine62</P></BODY></HTML> Fri, 08 Mar 2013 16:08:46 GMT 2013-03-08T16:08:46Z How to exclude certain values from a load https://community.qlik.com/t5/QlikView/How-to-exclude-certain-values-from-a-load/m-p/423495#M1155303 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've got load fields with values I want to exclude eg "#Null!","9", etc.&nbsp; Can one do this for individual fields?</P><P>Any help thanks,</P><P>Racine62</P></BODY></HTML> Fri, 08 Mar 2013 15:55:11 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-certain-values-from-a-load/m-p/423495#M1155303 2013-03-08T15:55:11Z Re: How to exclude certain values from a load https://community.qlik.com/t5/QlikView/How-to-exclude-certain-values-from-a-load/m-p/423496#M1155304 <HTML><HEAD></HEAD><BODY><P>1)</P><P>Select * from ...</P><P>Where Field1 &lt;&gt; null and Field1 &lt;&gt;'9' and Field2 &lt;&gt; '4'</P><P></P><P>Load data wher Field1 is not null and will never contain value 9 and field2 will never contain value 4</P></BODY></HTML> Fri, 08 Mar 2013 16:02:21 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-certain-values-from-a-load/m-p/423496#M1155304 alexandros17 2013-03-08T16:02:21Z Re: How to exclude certain values from a load https://community.qlik.com/t5/QlikView/How-to-exclude-certain-values-from-a-load/m-p/423497#M1155305 <HTML><HEAD></HEAD><BODY><P>Thanks for this,</P><P>Regards,</P><P>Racine62</P></BODY></HTML> Fri, 08 Mar 2013 16:08:46 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-certain-values-from-a-load/m-p/423497#M1155305 2013-03-08T16:08:46Z