Load Statement.

[#1]

How can i change the following Oracle 10g SH schema into Load statement in Qlikview:

Products:

SQL

"PROD_CATEGORY",

"PROD_CATEGORY_DESC",

"PROD_CATEGORY_ID",

"PROD_DESC",

"PROD_EFF_FROM",

"PROD_EFF_TO",

"PROD_ID",

"PROD_LIST_PRICE",

"PROD_MIN_PRICE",

"PROD_NAME",

"PROD_PACK_SIZE",

"PROD_SRC_ID",

"PROD_STATUS",

"PROD_SUBCATEGORY",

"PROD_SUBCATEGORY_DESC",

"PROD_SUBCATEGORY_ID",

"PROD_TOTAL",

"PROD_TOTAL_ID",

"PROD_UNIT_OF_MEASURE",

"PROD_VALID",

"PROD_WEIGHT_CLASS",

"SUPPLIER_ID"

FROM

SH.PRODUCTS; SELECT

[Anonymous]

You have to put SQL in front of select clause.

Products:

SQL select

"PROD_CATEGORY",

"PROD_CATEGORY_DESC",

"PROD_CATEGORY_ID",

"PROD_DESC",

"PROD_EFF_FROM",

"PROD_EFF_TO",

"PROD_ID",

"PROD_LIST_PRICE",

"PROD_MIN_PRICE",

"PROD_NAME",

"PROD_PACK_SIZE",

"PROD_SRC_ID",

"PROD_STATUS",

"PROD_SUBCATEGORY",

"PROD_SUBCATEGORY_DESC",

"PROD_SUBCATEGORY_ID",

"PROD_TOTAL",

"PROD_TOTAL_ID",

"PROD_UNIT_OF_MEASURE",

"PROD_VALID",

"PROD_WEIGHT_CLASS",

"SUPPLIER_ID"

FROM SH.PRODUCTS

[#3]

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...

Regards,

Khalid

[Anonymous · Accepted solution]

You can use preload statement like in example below:

SALES

load

*,

CANT*PRICE as VALUE;

sql select

PRODUCT,

CANT,

PRICE

from X.SALES;

I hope this is what you are looking for.

[#5]

Yes thanks, it helped and issue is resolved.

Many thanks,

Khalid

[#6]

Why this Query is not executing, can you specify any error in it please?

Sales:

Load

"AMOUNT_SOLD"

as "SALE AMOUNT_SOLD",

"CHANNEL_ID"

,

"CUST_ID"

,

"PROD_ID"

,

"PROMO_ID"

,

"QUANTITY_SOLD"

as "SALE QUANTITY_SOLD",

sum

("AMOUNT_SOLD"/"QUANTITY_SOLD" )*100 as "Sales",

"TIME_ID";

SQL

Select

"AMOUNT_SOLD",

"CHANNEL_ID",

"CUST_ID",

"PROD_ID",

"PROMO_ID",

"QUANTITY_SOLD",

"TIME_ID"

FROM

SH.SALES;

The error after the reload is given is this:

ODBC read failed
SQL Select
"AMOUNT_SOLD",
"CHANNEL_ID",
"CUST_ID",
"PROD_ID",
"PROMO_ID",
"QUANTITY_SOLD",
"TIME_ID"

FROM SH.SALES