topic Re: Field Not Found in LOAD in QlikView https://community.qlik.com/t5/QlikView/Field-Not-Found-in-LOAD/m-p/664693#M1061724 <HTML><HEAD></HEAD><BODY><P>OMG!!! C<SPAN style="color: #000000; font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; background-color: #fafafa;">an't see the forest for the trees...thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></SPAN></P></BODY></HTML> Tue, 23 Sep 2014 07:57:51 GMT 2014-09-23T07:57:51Z Field Not Found in LOAD https://community.qlik.com/t5/QlikView/Field-Not-Found-in-LOAD/m-p/664691#M1061722 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have Field not found error in the following load script, how can I fix???</P><P></P><P><STRONG>ERROR:Field not found - &lt;KA&gt;</STRONG></P><P></P><P>SALES_K:</P><P>LOAD&nbsp; DISTINCT <SPAN style="font-size: 13.6000003814697px;">NUM_SALES as</SPAN> KA </P><P style="font-size: 13.6000003814697px;">FROM</P><P style="font-size: 13.6000003814697px;">[..\QVD Data\Sales_2013.qvd]</P><P style="font-size: 13.6000003814697px;">(qvd);</P><P></P><P></P><P></P><P>SALES:</P><P>LOAD *&nbsp; FROM</P><P>[..\QVD Data\Sales_2013.qvd]</P><P>(qvd);</P><P>Concatenate</P><P>LOAD *&nbsp; FROM</P><P>[..\QVD Data\Sales_2014.qvd] where not exist (NUM_SALES,KA)</P><P>(qvd);</P><P></P><P>Thanks in advance,</P><P>Gino.</P></BODY></HTML> Mon, 22 Sep 2014 15:40:54 GMT https://community.qlik.com/t5/QlikView/Field-Not-Found-in-LOAD/m-p/664691#M1061722 2014-09-22T15:40:54Z Re: Field Not Found in LOAD https://community.qlik.com/t5/QlikView/Field-Not-Found-in-LOAD/m-p/664692#M1061723 <HTML><HEAD></HEAD><BODY><P>maybe </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">where not exist (KA, NUM_SALES)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">KA of SALES_K</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">NUM_SALES of 2014 qvd<BR /></SPAN></P></BODY></HTML> Mon, 22 Sep 2014 23:46:27 GMT https://community.qlik.com/t5/QlikView/Field-Not-Found-in-LOAD/m-p/664692#M1061723 maxgro 2014-09-22T23:46:27Z Re: Field Not Found in LOAD https://community.qlik.com/t5/QlikView/Field-Not-Found-in-LOAD/m-p/664693#M1061724 <HTML><HEAD></HEAD><BODY><P>OMG!!! C<SPAN style="color: #000000; font-family: Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif; font-size: 13px; background-color: #fafafa;">an't see the forest for the trees...thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></SPAN></P></BODY></HTML> Tue, 23 Sep 2014 07:57:51 GMT https://community.qlik.com/t5/QlikView/Field-Not-Found-in-LOAD/m-p/664693#M1061724 2014-09-23T07:57:51Z