topic Re: Download to QVD file creation script in QlikView

Download to QVD file creation script

Anonymous — Thu, 20 Jul 2017 11:50:51 GMT

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

Re: Download to QVD file creation script

Anil_Babu_Samineni — Thu, 20 Jul 2017 11:53:43 GMT

Here is the solution?

Re: Download to QVD file creation script

arvind_patil — Thu, 20 Jul 2017 11:56:10 GMT

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

Re: Download to QVD file creation script

Anonymous — Thu, 20 Jul 2017 11:59:08 GMT

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.

Re: Download to QVD file creation script

Anonymous — Thu, 20 Jul 2017 11:59:32 GMT

This causes the same error message.

Re: Download to QVD file creation script

Anil_Babu_Samineni — Thu, 20 Jul 2017 12:05:16 GMT

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;

Re: Download to QVD file creation script

Anonymous — Thu, 20 Jul 2017 12:05:32 GMT

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!

Re: Download to QVD file creation script

Anonymous — Thu, 20 Jul 2017 12:08:29 GMT

I am Glad it helps you.

Regards ,

Mahesh