topic AW:Load statement - Field not found in SQL script in QlikView https://community.qlik.com/t5/QlikView/Load-statement-Field-not-found-in-SQL-script/m-p/225023#M77378 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the QV language works like this:</P><P>Tablename:<BR />Load fieldname, fieldname2, ... fieldnamen;<BR />SQL Select * From Table;</P><P>Then load another table and use join or concatenate</P></BODY></HTML> Tue, 22 Feb 2011 12:29:21 GMT brenner_martina 2011-02-22T12:29:21Z Load statement - Field not found in SQL script https://community.qlik.com/t5/QlikView/Load-statement-Field-not-found-in-SQL-script/m-p/225022#M77377 <HTML><HEAD></HEAD><BODY><P>&lt;body&gt;&lt;p&gt;Hi,&lt;/p&gt; &lt;p&gt;I'm trying to run the following code but QV is returning the error:&nbsp;&nbsp; Field not found - &amp;lt;SettCcyAbbr&amp;gt;&lt;/p&gt; &lt;p&gt;Has anyone else experienced this problem/able to help please?&lt;/p&gt; &lt;p&gt;Many thanks,&lt;/p&gt; &lt;p&gt;Ronnie&lt;/p&gt; &lt;p&gt; &lt;p &gt;&lt;strong&gt;Set&lt;/strong&gt; &lt;/span&gt;[QVDPath]&lt;/span&gt; =&lt;/span&gt;'K:\COMMON\&lt;/span&gt;&lt;st1:stockticker&gt;DIS&lt;/span&gt;&lt;/st1:stockticker&gt;\1 Development &amp;amp; Implementation\Qlikview\2. Qlikview Project - Phase 1\2. QVD Layer\1. Wave1 Developments\Triangulations\QVD'&lt;/span&gt;;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;ODBC&lt;/strong&gt; &lt;strong&gt;CONNECT&lt;/strong&gt; &lt;strong&gt;TO&lt;/strong&gt; &lt;/span&gt;DBP0&lt;/span&gt;&lt;st1:stockticker&gt;DCS&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;(XUserId&lt;/span&gt; &lt;/span&gt;is&lt;/span&gt; &lt;/span&gt;ZYHTbINIEaVATYAKRC,&lt;/span&gt; &lt;/span&gt;XPassword&lt;/span&gt; &lt;/span&gt;is&lt;/span&gt; &lt;/span&gt;SaUDUYRNRZaMXUVMXTGB);&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;///$tab Q-Glob_Sett_Amts&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;i&gt;[Settlement]:&lt;/span&gt;&lt;/i&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;Load&lt;/strong&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;SettCcyAbbr, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;LloydsRiskCode&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;YearAccount&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;SystemYear&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;SystemQuarter&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;Prem_Amnt&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;[Prem _Amount_&lt;/span&gt;&lt;st1:stockticker&gt;GBP&lt;/span&gt;&lt;/st1:stockticker&gt;]&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;[Paid_Amnt]&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;[Paid_Amnt_&lt;/span&gt;&lt;st1:stockticker&gt;GBP&lt;/span&gt;&lt;/st1:stockticker&gt;]&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;[OS]&lt;/span&gt;, &lt;/span&gt;&lt;/p&gt; &lt;p &gt;[OS_&lt;/span&gt;&lt;st1:stockticker&gt;GBP&lt;/span&gt;&lt;/st1:stockticker&gt;];&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;SELECT&lt;/strong&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.Sett_Ccy_Abbr&lt;strong&gt; &lt;/strong&gt;&lt;/span&gt;as SettCcyAbbr,&lt;strong&gt; &lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.Lloyds_Risk_Code&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;LloydsRiskCode,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.Year_Account&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;YearAccount,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.Year&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;SystemYear,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.Quarter&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;SystemQuarter,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;-SUM(COALESCE(AL6.Premium_Amt,0))&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;PremAmnt,&lt;/span&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;-SUM(COALESCE(float&lt;/span&gt; &lt;/span&gt;(&lt;/span&gt; &lt;/span&gt;AL6.Premium_Amt&lt;/span&gt; &lt;/span&gt;)&lt;/span&gt; &lt;/span&gt;/float&lt;/span&gt; &lt;/span&gt;(&lt;/span&gt; &lt;/span&gt;AL6.EX_&lt;/span&gt;&lt;st1:stockticker&gt;RATE&lt;/span&gt;&lt;/st1:stockticker&gt;_TO_STRL&lt;/span&gt; &lt;/span&gt;)&lt;/span&gt; &lt;/span&gt;,0))&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;Prem_Amount_&lt;/span&gt;&lt;st1:stockticker&gt;GBP&lt;/span&gt;&lt;/st1:stockticker&gt;,&lt;/span&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;-SUM(COALESCE(AL6.Claim_Amt,0))&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;Paid_Amnt,&lt;/span&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;-SUM(COALESCE(float&lt;/span&gt; &lt;/span&gt;(&lt;/span&gt; &lt;/span&gt;AL6.Claim_Amt&lt;/span&gt; &lt;/span&gt;)&lt;/span&gt; &lt;/span&gt;/&lt;/span&gt; &lt;/span&gt;float&lt;/span&gt; &lt;/span&gt;(&lt;/span&gt; &lt;/span&gt;AL6.EX_&lt;/span&gt;&lt;st1:stockticker&gt;RATE&lt;/span&gt;&lt;/st1:stockticker&gt;_TO_STRL&lt;/span&gt; &lt;/span&gt;)&lt;/span&gt; &lt;/span&gt;,0))&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;Paid_Amnt_&lt;/span&gt;&lt;st1:stockticker&gt;GBP&lt;/span&gt;&lt;/st1:stockticker&gt;,&lt;/span&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;-sum(COALESCE(AL6.Os_Total_Orig,0))&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;OS,&lt;/span&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;-SUM(COALESCE(float&lt;/span&gt; &lt;/span&gt;(&lt;/span&gt; &lt;/span&gt;AL6.Os_total_orig&lt;/span&gt; &lt;/span&gt;)&lt;/span&gt; &lt;/span&gt;/float&lt;/span&gt; &lt;/span&gt;(&lt;/span&gt; &lt;/span&gt;AL6.EX_&lt;/span&gt;&lt;st1:stockticker&gt;RATE&lt;/span&gt;&lt;/st1:stockticker&gt;_TO_STRL&lt;/span&gt; &lt;/span&gt;)&lt;/span&gt; &lt;/span&gt;,0))&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;OS_&lt;/span&gt;&lt;st1:stockticker&gt;GBP&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;FROM&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;(SELECT&lt;/span&gt;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;OUTER.Sett_Ccy_Abbr,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;OUTER.Lloyds_Risk_Code,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;OUTER.Year_Account,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;OUTER.Year,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;OUTER.Quarter,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;DETAILS.Premium_Amt,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;DETAILS.Claim_Amt,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;DETAILS.OS_Total_Orig,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;DETAILS.ex_rate_to_strl&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;From&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;(SELECT&lt;/span&gt;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;AL1.Sett_Ccy_Abbr,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.Lloyds_Risk_Code,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.Year_Account,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.Quarter_No,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.System_Year,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.Premium_Amt,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.Claim_Amt,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.OS_Total_Orig,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL1.ex_rate_to_strl&lt;/span&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;From&lt;/strong&gt; &lt;/span&gt;&lt;st1:stockticker&gt;PEP&lt;/span&gt;&lt;/st1:stockticker&gt;0MGR.TWAB90_GLOBAL_AGG&lt;/span&gt; &lt;/span&gt;AL1&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;)&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;DETAILS&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;RIGHT&lt;/span&gt; &lt;/span&gt;OUTER&lt;/span&gt; &lt;/span&gt;JOIN&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;(SELECT&lt;/span&gt; &lt;/span&gt;AL3.Year_Account,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL5.Lloyds_Risk_Code,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL5.Sett_Ccy_Abbr,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL4.Year,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL4.Quarter&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;From&lt;/strong&gt; &lt;/span&gt;&lt;st1:stockticker&gt;PEP&lt;/span&gt;&lt;/st1:stockticker&gt;0MGR.TWAB94_GL_SR_&lt;/span&gt;&lt;st1:stockticker&gt;REF&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;AL5,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;PEP&lt;/span&gt;&lt;/st1:stockticker&gt;0MGR.TWAB96_YOA_&lt;/span&gt;&lt;st1:stockticker&gt;REF&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;AL3,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;PEP&lt;/span&gt;&lt;/st1:stockticker&gt;0MGR.TWAB97_DATES_&lt;/span&gt;&lt;st1:stockticker&gt;REF&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;AL4&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;WHERE&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;AL3.Year_Account&lt;/span&gt; &lt;/span&gt;&amp;lt;=&lt;/span&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;AL4.Year&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;AL4.YEAR&amp;gt;=1993&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;AL3.YEAR_ACCOUNT&amp;gt;=1993&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;1=1&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;1=1&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;NOT&lt;/span&gt; &lt;/span&gt;EXISTS&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;(SELECT&lt;/span&gt; &lt;/span&gt;*&lt;/span&gt; &lt;strong&gt;from&lt;/strong&gt; &lt;/span&gt;&lt;st1:stockticker&gt;PEP&lt;/span&gt;&lt;/st1:stockticker&gt;0MGR.TWAT76_RSK_EXCLUDE&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;where&lt;/span&gt; &lt;/span&gt;lloyds_risk_code&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;=&lt;/span&gt; &lt;/span&gt;AL5.lloyds_risk_code&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;system_year&lt;/span&gt; &lt;/span&gt;&amp;gt;&lt;/span&gt; &lt;/span&gt;AL3.year_account)&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;)&lt;/span&gt; &lt;/span&gt;as&lt;/span&gt; &lt;/span&gt;OUTER&lt;/span&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;ON&lt;/span&gt;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;OUTER.Sett_Ccy_Abbr&lt;/span&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;=&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;DETAILS.Sett_Ccy_Abbr&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;&lt;/span&gt;OUTER.Lloyds_Risk_Code&lt;/span&gt;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;=&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;DETAILS.Lloyds_Risk_Code&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;&lt;/span&gt;OUTER.Year_Account&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;=&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;DETAILS.Year_Account&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;&lt;/span&gt;OUTER.Quarter&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;=&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;DETAILS.Quarter_No&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt; &lt;/span&gt;&lt;/span&gt;OUTER.Year&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;=&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;DETAILS.System_Year&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;)&lt;/span&gt; &lt;/span&gt;AS&lt;/span&gt; &lt;/span&gt;AL6&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;Where&lt;/span&gt; &lt;/span&gt;1=1&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;st1:stockticker&gt;AND&lt;/span&gt;&lt;/st1:stockticker&gt;&nbsp; &lt;/span&gt;&lt;/span&gt;1=1&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;GROUP&lt;/span&gt; &lt;/span&gt;BY&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.Sett_Ccy_Abbr,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.LLOYDS_RISK_CODE,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.YEAR_ACCOUNT,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.YEAR,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.QUARTER&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;ORDER&lt;/span&gt; &lt;/span&gt;BY&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.Sett_Ccy_Abbr,&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.LLOYDS_RISK_CODE,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.YEAR_ACCOUNT,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.YEAR,&lt;/span&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;AL6.QUARTER;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&lt;strong&gt;Store&lt;/strong&gt; &lt;/span&gt;[Settlement]&lt;/span&gt; &lt;strong&gt;into&lt;/strong&gt; &lt;/span&gt;&lt;i&gt;&lt;strong&gt;$(QVDPath)&lt;/strong&gt;&lt;/span&gt;&lt;/i&gt;Triang_Settlement.qvd; &lt;/span&gt;&lt;/p&gt; &lt;p style="margin: 0cm 0cm 0pt;" &gt;&nbsp;&lt;/span&gt;&lt;/p&gt; &lt;p style="margin: 0cm 0cm 0pt;" &gt;&nbsp;&lt;/span&gt;&lt;/p&gt; &lt;p &gt;&nbsp;&lt;/p&gt; &lt;/span&gt;&lt;/p&gt; &lt;p &gt;&nbsp;&lt;/p&gt;&lt;/body&gt;</P></BODY></HTML> Tue, 22 Feb 2011 12:23:53 GMT https://community.qlik.com/t5/QlikView/Load-statement-Field-not-found-in-SQL-script/m-p/225022#M77377 2011-02-22T12:23:53Z AW:Load statement - Field not found in SQL script https://community.qlik.com/t5/QlikView/Load-statement-Field-not-found-in-SQL-script/m-p/225023#M77378 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the QV language works like this:</P><P>Tablename:<BR />Load fieldname, fieldname2, ... fieldnamen;<BR />SQL Select * From Table;</P><P>Then load another table and use join or concatenate</P></BODY></HTML> Tue, 22 Feb 2011 12:29:21 GMT https://community.qlik.com/t5/QlikView/Load-statement-Field-not-found-in-SQL-script/m-p/225023#M77378 brenner_martina 2011-02-22T12:29:21Z