Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
sugam_mercer
New Contributor

Table Not Found error when storing table as QVD

Hi Everyone,

When I try to run the following script, I get an error message which says 'Table Not Found' and it mentions that error is generated at the Store statement.

STUDENT1_STUDENT2: LOAD student_id, student_name, city, age from [C:\Users\Username\Documents\Qlik\Sense\Apps\DataPrepAppCache\STUDENT1.qvd] (qvd);

LEFT JOIN LOAD student_id, department, college, rank from [C:\Users\Username\Documents\Qlik\Sense\Apps\DataPrepAppCache\STUDENT2.qvd] (qvd);

STORE STUDENT1_STUDENT2 into [C:\Users\Username\Documents\Qlik\Sense\Apps\DataPrepAppCache\STUDENT1_STUDENT2_data.qvd];

When I comment the store statement, the script executes.

May I request you to please help me in executing the script with the store statement.

Thank You !

Regards

Labels (1)
7 Replies
Claudiu_Anghelescu
Valued Contributor

Re: Table Not Found error when storing table as QVD

STORE STUDENT1_STUDENT2 into [..\DataPrepAppCache\STUDENT1_STUDENT2_data.qvd] (qvd);
To help community find solutions, please don't forget to mark as correct.
sugam_mercer
New Contributor

Re: Table Not Found error when storing table as QVD

Hi Claudiu,

Thanks for the response.

I tried appending (qvd) at the end of the STORE statement, but the issue persists. Table 'STUDENT1_STUDENT2' not found.

I thought the (qvd) part is meant to be added only when we LOAD from QVD (qvd).

Regards

Claudiu_Anghelescu
Valued Contributor

Re: Table Not Found error when storing table as QVD

Try to comment the second syntax (LEFT).
To help community find solutions, please don't forget to mark as correct.
sugam_mercer
New Contributor

Re: Table Not Found error when storing table as QVD

Tried commenting LEFT as well. Issue Persists.

Earlier I was able to left join two qvds in the same way, but not happening now. Does the order of the columns matter? I tried changing the order, but still getting the issue.

Thanks.

mwoolf
Honored Contributor II

Re: Table Not Found error when storing table as QVD

Try putting an Exit Script after the first load and see if you have a table named "STUDENT1_STUDENT2".

If yes, move the Exit Script after the Left join load, and check again for "STUDENT1_STUDENT2".

sugam_mercer
New Contributor

Re: Table Not Found error when storing table as QVD

Hi Mwoolf,

Thanks for the response.

I will find out more about the Exit Script that you have suggested and will implement it in the way you have mentioned.

I will revert as soon as I implement the Exit Script.

Thank You !

Regards

Support
Support

Re: Table Not Found error when storing table as QVD

Here is some help for the Exit Script:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Scr...

I believe the guys are on track here, it seems something weird is going on in the load, so hopefully completing the script change and checking the data model will confirm things.

As an alternative, you may be just be able to do this by commenting the Store statement as you were doing and checking the data model after things complete to be sure the table is there by the correct name etc.  

One other thing did pop into my mind though, potentially if that qvd is already open, that may cause the Store to fail as well, as we would not be able to get the exclusive lock on the file to be able to write it, so another test you could do is simply change the name of the qvd file once to see if it then writes or not, be sure to name it something you know you do not already have out there just to be safe.

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.