Resident Load error

[#1]

Hello ,

I am trying to test a simple resident load scenario and below is my script.

Stored_Products:

LOAD Product_Id,

    Product_Line,

    Product_category,

    Product_Subcategory

FROM

C:\qlikview\Practice\qvds\Products.qvd(QVD);

Y:

Load max(Product_Id) as MaxId

resident Stored_Products;

When I run this, I am getting an error saying that Table Not Found : Y.  Am I missing something here? Can you guys please help me out.

Thank You!

[m_woolf]

Y:

NOCONCATENATE Load max(Product_Id) as MaxId

[maxgro]

I think the Stored_Products table doesn't exists; try to add an exit and see in the table viewer (ctrl-t) if the table exists

Stored_Products:

LOAD Product_Id,

    Product_Line,

    Product_category,

    Product_Subcategory

FROM

C:\qlikview\Practice\qvds\Products.qvd(QVD);

exit script;

[Clever_Anjos · Accepted solution]

Try

Stored_Products:

noconcatenate LOAD Product_Id,

    Product_Line,

    Product_category,

    Product_Subcategory

FROM

C:\qlikview\Practice\qvds\Products.qvd(QVD);

Y:

Load max(Product_Id) as MaxId

resident Stored_Products;

[#5]

Thank You!

[#6]

Thank You!

[#7]

Thank You!