Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
Specialist
Specialist

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

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

Highlighted
Specialist
Specialist

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

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.

Highlighted
Master II
Master II

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

Highlighted
Contributor
Contributor

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

Highlighted
Digital Support
Digital Support

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.