Script Error

[suvechha_b]

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";

[marcus_malinow · Accepted solution]

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