Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Here is the solution?
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
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.
This causes the same error message.
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;
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!
I am Glad it helps you.
Regards ,
Mahesh