topic Load Statement. in QlikView https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183866#M48975 <HTML><HEAD></HEAD><BODY><P></P><P>How can i change the following Oracle 10g SH schema into Load statement in Qlikview:</P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P style="font-style: italic"></P><P style="font-style: italic">Products:</P><B></B><P style="font-weight: bold">SQL</P><B></B><P style="font-weight: bold"></P><P></P><P>"PROD_CATEGORY",</P><P>"PROD_CATEGORY_DESC",</P><P>"PROD_CATEGORY_ID",</P><P></P><BR /><BR /> <P></P><P></P><P>"PROD_DESC",</P><P>"PROD_EFF_FROM",</P><P>"PROD_EFF_TO",</P><P>"PROD_ID",</P><P></P><P></P><P></P><P>"PROD_LIST_PRICE",</P><P>"PROD_MIN_PRICE",</P><P>"PROD_NAME",</P><P></P><P></P><P></P><P>"PROD_PACK_SIZE",</P><P>"PROD_SRC_ID",</P><P>"PROD_STATUS",</P><P></P><P></P><P></P><P>"PROD_SUBCATEGORY",</P><P>"PROD_SUBCATEGORY_DESC",</P><P></P><P></P><P></P><P>"PROD_SUBCATEGORY_ID",</P><P>"PROD_TOTAL",</P><P>"PROD_TOTAL_ID",</P><P></P><P></P><P></P><P>"PROD_UNIT_OF_MEASURE",</P><P>"PROD_VALID",</P><P></P><P></P>"PROD_WEIGHT_CLASS", <P></P><P>"SUPPLIER_ID"</P><B></B><P style="font-weight: bold">FROM</P><B></B><P style="font-weight: bold"></P><P></P>SH.PRODUCTS; <B>SELECT</B> <BR /><BR /> <BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 10 Jun 2010 11:36:47 GMT 2010-06-10T11:36:47Z Load Statement. https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183866#M48975 <HTML><HEAD></HEAD><BODY><P></P><P>How can i change the following Oracle 10g SH schema into Load statement in Qlikview:</P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P style="font-style: italic"></P><P style="font-style: italic">Products:</P><B></B><P style="font-weight: bold">SQL</P><B></B><P style="font-weight: bold"></P><P></P><P>"PROD_CATEGORY",</P><P>"PROD_CATEGORY_DESC",</P><P>"PROD_CATEGORY_ID",</P><P></P><BR /><BR /> <P></P><P></P><P>"PROD_DESC",</P><P>"PROD_EFF_FROM",</P><P>"PROD_EFF_TO",</P><P>"PROD_ID",</P><P></P><P></P><P></P><P>"PROD_LIST_PRICE",</P><P>"PROD_MIN_PRICE",</P><P>"PROD_NAME",</P><P></P><P></P><P></P><P>"PROD_PACK_SIZE",</P><P>"PROD_SRC_ID",</P><P>"PROD_STATUS",</P><P></P><P></P><P></P><P>"PROD_SUBCATEGORY",</P><P>"PROD_SUBCATEGORY_DESC",</P><P></P><P></P><P></P><P>"PROD_SUBCATEGORY_ID",</P><P>"PROD_TOTAL",</P><P>"PROD_TOTAL_ID",</P><P></P><P></P><P></P><P>"PROD_UNIT_OF_MEASURE",</P><P>"PROD_VALID",</P><P></P><P></P>"PROD_WEIGHT_CLASS", <P></P><P>"SUPPLIER_ID"</P><B></B><P style="font-weight: bold">FROM</P><B></B><P style="font-weight: bold"></P><P></P>SH.PRODUCTS; <B>SELECT</B> <BR /><BR /> <BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 10 Jun 2010 11:36:47 GMT https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183866#M48975 2010-06-10T11:36:47Z Load Statement. https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183867#M48976 <HTML><HEAD></HEAD><BODY><P style="font-style: italic"></P><P style="font-style: italic">You have to put SQL in front of select clause.</P><P style="font-style: italic"></P><P style="font-style: italic">Products:</P><B></B><P><B>SQL</B> select</P><P></P><P>"PROD_CATEGORY",</P><BR /><BR /> <P>"PROD_CATEGORY_DESC",</P><P>"PROD_CATEGORY_ID",</P><P></P><P>"PROD_DESC",</P><BR /><BR /> <P>"PROD_EFF_FROM",</P><P>"PROD_EFF_TO",</P><P>"PROD_ID",</P><P></P><P>"PROD_LIST_PRICE",</P><BR /><BR /> <P>"PROD_MIN_PRICE",</P><P>"PROD_NAME",</P><P></P><P>"PROD_PACK_SIZE",</P><BR /><BR /> <P>"PROD_SRC_ID",</P><P>"PROD_STATUS",</P><P></P><P>"PROD_SUBCATEGORY",</P><BR /><BR /> <P>"PROD_SUBCATEGORY_DESC",</P><P></P><P>"PROD_SUBCATEGORY_ID",</P><BR /><BR /> <P>"PROD_TOTAL",</P><P>"PROD_TOTAL_ID",</P><P></P><P>"PROD_UNIT_OF_MEASURE",</P><P>"PROD_VALID",</P><P>"PROD_WEIGHT_CLASS",</P><P></P><P>"SUPPLIER_ID"</P><B></B><P><B>FROM</B> SH.PRODUCTS</P><BR /><BR /></BODY></HTML> Thu, 10 Jun 2010 11:43:23 GMT https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183867#M48976 Anonymous 2010-06-10T11:43:23Z Load Statement. https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183868#M48977 <HTML><HEAD></HEAD><BODY><P>Yes you are right, it must have been the typing or cpoy paste problem, but I wanted to know that how should i convert this statement and table in Load statement...</P><P>Regards,</P><P>Khalid</P></BODY></HTML> Thu, 10 Jun 2010 11:53:54 GMT https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183868#M48977 2010-06-10T11:53:54Z Load Statement. https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183869#M48978 <HTML><HEAD></HEAD><BODY><P>You can use preload statement like in example below:</P><P style="font-style: italic">SALES</P><P style="font-weight: bold">load</P><P style="font-weight: bold">*,</P><P style="font-weight: bold">CANT*PRICE as VALUE;</P><P>sql select</P><P>PRODUCT,</P><P>CANT,</P><P>PRICE</P><P>from X.SALES;</P><P></P><P>I hope this is what you are looking for.</P><P></P></BODY></HTML> Thu, 10 Jun 2010 12:04:36 GMT https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183869#M48978 Anonymous 2010-06-10T12:04:36Z Load Statement. https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183870#M48979 <HTML><HEAD></HEAD><BODY><P>Yes thanks, it helped and issue is resolved.</P><P>Many thanks,</P><P>Khalid</P></BODY></HTML> Thu, 10 Jun 2010 12:11:58 GMT https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183870#M48979 2010-06-10T12:11:58Z Load Statement. https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183871#M48980 <HTML><HEAD></HEAD><BODY><P>Why this Query is not executing, can you specify any error in it please?</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P style="font-style: italic"></P><P style="font-style: italic">Sales:</P><B></B><P style="font-weight: bold">Load</P><P>"AMOUNT_SOLD"</P><P></P><P><B>as</B> "SALE AMOUNT_SOLD",</P><P>"CHANNEL_ID"</P><P></P><P>,</P><P>"CUST_ID"</P><P></P><P>,</P><P>"PROD_ID"</P><P></P><P>,</P><P>"PROMO_ID"</P><P></P><P>,</P><P>"QUANTITY_SOLD"</P><P></P><P><B>as</B> "SALE QUANTITY_SOLD",</P><P>sum</P><P></P><P>("AMOUNT_SOLD"/"QUANTITY_SOLD" )*100 <B>as</B> "Sales",</P><P>"TIME_ID";</P><B></B><P style="font-weight: bold">SQL</P><B></B><P style="font-weight: bold"></P><P></P><B>Select</B> <P>"AMOUNT_SOLD",</P><P>"CHANNEL_ID",</P><P></P><P></P><P></P><P>"CUST_ID",</P><P></P><P></P><P></P><P>"PROD_ID",</P><P>"PROMO_ID",</P><P></P><P></P><P></P><P>"QUANTITY_SOLD",</P><P>"TIME_ID"</P><B></B><P style="font-weight: bold">FROM</P><B></B><P style="font-weight: bold"></P><P></P>SH.SALES; <BR /><BR /> <P></P><P style="margin:0in 0in 0pt;">The error after the reload is given is this:</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">ODBC read failed<BR />SQL Select<BR />"AMOUNT_SOLD",<BR />"CHANNEL_ID",<BR />"CUST_ID",<BR />"PROD_ID",<BR />"PROMO_ID",<BR />"QUANTITY_SOLD",<BR />"TIME_ID"<BR /></P><P style="margin:0in 0in 0pt;">FROM SH.SALES</P><BR /><BR /></BODY></HTML> Thu, 10 Jun 2010 12:28:43 GMT https://community.qlik.com/t5/QlikView/Load-Statement/m-p/183871#M48980 2010-06-10T12:28:43Z