Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have 10 qvd files. I need to make them as single qvd file. Could you please any one describe this?
Hello Siva,
That sounds strange. If you concatenate only two or three files manually as specified here, is the file still empty?
Regards
BI Consultant
Hi Miguel,
I have multiple qvd;s for multiple years in one folder. What I want to do is store 2015* qvd's into one and 2016* qvd's into another. I want to store these qvd's in the same folder. Did the following but when doing this from one qvw, reload failed with an
Error: Table 'Test2016' not found
// This loads all files in one table
Test2015:
LOAD *
FROM [..\..\_Test\qvd\TEST_2015*.qvd] (qvd);
// This stores all previous QVDs in one
STORE Test2015 INTO [..\..\_Test\qvd\TEST_2015.qvd];
// This loads all files in one table
Test2016:
LOAD *
FROM [..\..\_Test\qvd\TEST_2016*.qvd] (qvd);
// This stores all previous QVDs in one
STORE Test2016 INTO [..\..\_Test\qvd\TEST_2016.qvd];
Please advise.
Thanks
Hello, the solution for this is, we have to drop table 'Test2015' before loading Test2016 table.
I faced similar problem. I'm saving qvd's per day x10 reports. So there's huge number of files. I'm concerning about file count. Is it an unnecessary worry?
i try same logic on my tables it will filed
it showing
-129 =
2018-08-02 15:18:56 Execution Failed