Download to QVD file creation script

[Anonymous]

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

[Anil_Babu_Samineni]

Here is the solution?

[arvind_patil]

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 · Accepted solution]

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]

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;

[Anonymous]

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]

I am Glad it helps you.

Regards ,

Mahesh