Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
davidmcfall
New Contributor

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
kjmahesh
Contributor

Re: Download to QVD file creation script

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.

7 Replies

Re: Download to QVD file creation script

Here is the solution?

Life is so rich, and we need to respect to the life !!!
arvind_patil
Valued Contributor III

Re: Download to QVD file creation script

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

kjmahesh
Contributor

Re: Download to QVD file creation script

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.

davidmcfall
New Contributor

Re: Download to QVD file creation script

This causes the same error message.

Re: Download to QVD file creation script

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;

Life is so rich, and we need to respect to the life !!!
davidmcfall
New Contributor

Re: Download to QVD file creation script

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!

kjmahesh
Contributor

Re: Download to QVD file creation script

I am Glad it helps you.

Regards ,

Mahesh

Community Browser