Table Not Found error when storing table as QVD

[sugam_mercer]

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

[Claudiu_Anghelescu]

STORE STUDENT1_STUDENT2 into [..\DataPrepAppCache\STUDENT1_STUDENT2_data.qvd] (qvd);

[sugam_mercer]

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]

Try to comment the second syntax (LEFT).

[sugam_mercer]

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.

[m_woolf]

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]

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

[Brett_Bleess]

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