Script Error

suvechha_b — Thu, 07 Nov 2013 11:36:33 GMT

I have a fact :

"SupplierOrders":

LOAD

"product_key",

"warehouse_key",

"customer_key",

"Delivered Qty",

"Picked Qty",

"OutStanding Amount";

SQL SELECT

product_key,

customer_key,

warehouse_key,

[Delivered Qty],

[Picked Qty],

[OutStanding Amount]

FROM edw.dbo."qlk_fact_invoiced_orders";

Dimension :

"Customer":

LOAD "customer_key",

"Customer Company Code",

"Customer Code",

"Customer Code Name",

"Province Name",

"Customer Name";

SQL SELECT *

FROM edw.dbo."qlk_dim_customer";

INNER JOIN

LOAD customer_key

RESIDENT CustomerKey;

DROP TABLE CustomerKey;

and

"CustomerKey":

LOAD DISTINCT customer_key

RESIDENT "SalesOpenOrders";

I want to use this as because I want to restrict customer_key

There is an scrit error that :

Table not found

LOAD DISTINCT customer_key

RESIDENT "SalesOpenOrders";

Re: Script Error

marcus_malinow — Thu, 07 Nov 2013 11:39:52 GMT

Hi,

the error is occurring because you haven't created the SalesOpenOrders table. Are you sure you aren't meaning to use the SupplierOrders table?

Also you don't need to enclose your table names in quotes.

Marcus

topic Script Error in QlikView

Script Error

Re: Script Error