topic How does preceeding load know how to stop loading tables? in QlikView https://community.qlik.com/t5/QlikView/How-does-preceeding-load-know-how-to-stop-loading-tables/m-p/221378#M74196 <HTML><HEAD></HEAD><BODY><P>A preceding load will stop when it hits a semicolon that is located after the next table. For example:</P><P>LOAD<BR /> CategoryID,<BR /> CategoryName,<BR /> Description;<BR />SQL SELECT *<BR />FROM Categories;</P><P>In this example, the first semicolon (after Description) will stop the preceding load and the second semicolon (after Categories) will tell the preceding load where to get data from. Other data sources than SQL only require the second semicolon.</P><P>Hope this helped,</P></BODY></HTML> Mon, 25 Jan 2010 17:35:52 GMT vgutkovsky 2010-01-25T17:35:52Z How does preceeding load know how to stop loading tables? https://community.qlik.com/t5/QlikView/How-does-preceeding-load-know-how-to-stop-loading-tables/m-p/221377#M74195 <HTML><HEAD></HEAD><BODY><P>Quick question I am using preceeding load which is very useful but how do you stop a table beneath the preceeding load being included?</P><P></P><P></P><P></P></BODY></HTML> Mon, 25 Jan 2010 12:01:38 GMT https://community.qlik.com/t5/QlikView/How-does-preceeding-load-know-how-to-stop-loading-tables/m-p/221377#M74195 2010-01-25T12:01:38Z How does preceeding load know how to stop loading tables? https://community.qlik.com/t5/QlikView/How-does-preceeding-load-know-how-to-stop-loading-tables/m-p/221378#M74196 <HTML><HEAD></HEAD><BODY><P>A preceding load will stop when it hits a semicolon that is located after the next table. For example:</P><P>LOAD<BR /> CategoryID,<BR /> CategoryName,<BR /> Description;<BR />SQL SELECT *<BR />FROM Categories;</P><P>In this example, the first semicolon (after Description) will stop the preceding load and the second semicolon (after Categories) will tell the preceding load where to get data from. Other data sources than SQL only require the second semicolon.</P><P>Hope this helped,</P></BODY></HTML> Mon, 25 Jan 2010 17:35:52 GMT https://community.qlik.com/t5/QlikView/How-does-preceeding-load-know-how-to-stop-loading-tables/m-p/221378#M74196 vgutkovsky 2010-01-25T17:35:52Z