Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Download to QVD file creation script

Hi,

I am looking to add an additional .qvd file to my scheduled download file - My current script is attached, which is working successfully.

However, when I want to add a new line to the script, also attached, I receive a table not found error for the new .qvd file.

Is there a step I am missing?

Regards

David

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

HI David,

Do you have same field names between these tables?  If yes  QlikView  functionality  automatically concatenates  tables if it has same field names

Suppose  Myfile3 table concatenate with  your new table. you will not find new table anymore to store into QVD.

Hope  it helps

Thanks

Mahesh.

View solution in original post

7 Replies
Anil_Babu_Samineni

Here is the solution?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi David,

Kindly check first table available in schema or not. I think error occur in below-highlighted line. Please check spell mistakes too.

Myfile6:

SQL SELECT *

FROM Hydrogarden.dbo."HWS_SALES_DATA_CUBE_MASTER_TEST";

Thanks,

Arvind Patil

Anonymous
Not applicable
Author

HI David,

Do you have same field names between these tables?  If yes  QlikView  functionality  automatically concatenates  tables if it has same field names

Suppose  Myfile3 table concatenate with  your new table. you will not find new table anymore to store into QVD.

Hope  it helps

Thanks

Mahesh.

Anonymous
Not applicable
Author

This causes the same error message.

Anil_Babu_Samineni

Last solution from my end is, If you have access DB then try and show me how records are looks like? And tell me whether this is Table / View / Procedure ???

SELECT * FROM Hydrogarden.dbo.HWS_SALES_DATA_CUBE_MASTER_TEST;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Yes - It is the same data, with a slight change. Using your suggestion I created a second tab and loaded the items separately - No more error messages!

Anonymous
Not applicable
Author

I am Glad it helps you.

Regards ,

Mahesh