topic &quot;Syntax error, missing/misplaced FROM: in QlikView https://community.qlik.com/t5/QlikView/quot-Syntax-error-missing-misplaced-FROM/m-p/240506#M91023 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>You should change<BR />" ShipmentDate, " to " ShipmentDate; " as this is the last field to load before making the SELECT statement.</P><P>__<BR />Jens</P></BODY></HTML> Tue, 03 Aug 2010 06:10:10 GMT 2010-08-03T06:10:10Z "Syntax error, missing/misplaced FROM: https://community.qlik.com/t5/QlikView/quot-Syntax-error-missing-misplaced-FROM/m-p/240505#M91022 <HTML><HEAD></HEAD><BODY>Hi, I am going through the Course - Developer 1 Version 9 e-Learning: Currently, I am working on : Module 6- Synthetic Keys and circular references I am stuck up at the following code.. LOAD //CustomerID, //EmployeeID, //LineNo, // OrderID, autonumber(OrderID &amp; '|' &amp; LineNo) as Orderlinekey, // ProductID, ShipmentDate, // ShipperID; SQL SELECT * FROM Shipments; I am getting the following error. " "Syntax error, missing/misplaced FROM: LOAD autonumber(OrderID &amp; '|' &amp; LineNo) as Orderlinekey, ShipmentDate, SQL SELECT * FROM Shipments LOAD autonumber(OrderID &amp; '|' &amp; LineNo) as Orderlinekey, ShipmentDate, SQL SELECT * FROM Shipments" I can not solve this.. why I am not able to use the <span class="lia-unicode-emoji" title=":grinning_squinting_face:">😆</span> autonumber(OrderID &amp; '|' &amp; LineNo) as Orderlinekey, Please help</BODY></HTML> Tue, 03 Aug 2010 05:53:56 GMT https://community.qlik.com/t5/QlikView/quot-Syntax-error-missing-misplaced-FROM/m-p/240505#M91022 2010-08-03T05:53:56Z "Syntax error, missing/misplaced FROM: https://community.qlik.com/t5/QlikView/quot-Syntax-error-missing-misplaced-FROM/m-p/240506#M91023 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>You should change<BR />" ShipmentDate, " to " ShipmentDate; " as this is the last field to load before making the SELECT statement.</P><P>__<BR />Jens</P></BODY></HTML> Tue, 03 Aug 2010 06:10:10 GMT https://community.qlik.com/t5/QlikView/quot-Syntax-error-missing-misplaced-FROM/m-p/240506#M91023 2010-08-03T06:10:10Z "Syntax error, missing/misplaced FROM: https://community.qlik.com/t5/QlikView/quot-Syntax-error-missing-misplaced-FROM/m-p/240507#M91024 <HTML><HEAD></HEAD><BODY>Hi Jens, Yes!! this is working now.. Thanks a lot..</BODY></HTML> Tue, 03 Aug 2010 06:19:15 GMT https://community.qlik.com/t5/QlikView/quot-Syntax-error-missing-misplaced-FROM/m-p/240507#M91024 2010-08-03T06:19:15Z