topic Re: Resident Load error in QlikView

Resident Load error

Wed, 20 Jul 2016 18:40:03 GMT

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

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!

Re: Resident Load error

m_woolf — Wed, 20 Jul 2016 18:54:49 GMT

NOCONCATENATE Load max(Product_Id) as MaxId

Re: Resident Load error

maxgro — Wed, 20 Jul 2016 18:55:25 GMT

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;

Re: Resident Load error

Clever_Anjos — Wed, 20 Jul 2016 18:56:45 GMT

Try

Stored_Products:

noconcatenate LOAD Product_Id,

Product_Line,

Product_category,

Product_Subcategory

FROM

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

Load max(Product_Id) as MaxId

resident Stored_Products;

Re: Resident Load error

Wed, 20 Jul 2016 19:02:26 GMT

Thank You!

Re: Resident Load error

Wed, 20 Jul 2016 19:02:39 GMT

Thank You!

Re: Resident Load error

Wed, 20 Jul 2016 19:02:50 GMT

Thank You!