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?
Hi Miguel,
Thank you
Sridhar wrote "Moreover if the Qvd`s has different field names, then my code will create a QVD only for the 1st loaded table and it will not create a QVD for subsequent loaded tables."
It is not necessary for all qvd files to have same fields. You can load fields with different names by using 'cocatenate load' and then store the table to 'Final.qvd'. Something like:
Tab1:
Load * from file1.qvd;
cocatenate load * from file2.qvd;
cocatenate load * from file3.qvd;
store * from Tab1 into Fianl.qvd
Darshan
Hi Darshan,
That's right, but it takes more time to develop and you need to specify each of the files you want to concatenate, while when using the wildcard in the filename provided all fields are the same, the concatenation takes places likewise, and the code is cleaner.
I use that quite a lot in my projects.
Regards.
BI Consultant
Hi Miguel,
I tried to store all qvds into one qvd as per your suggession. Yes, its working as well. But when Im going to see the final qvd. It is not showing any data. May I know why?
Hi Miguel,
If the aim is to load qvd files with different field names and create a single qvd file for further use, one can use the wild card for filename in my example as well. You may either keep the initial qvd files in a separate project directory or give them project related names like P1F1.qvd, P1F2.qvd and so on. You may then use "concatenate load * from *.qvd " if they are in a separate project directory, otherwise "concatenate load * from P1*.qvd ".
Hope this clarifies
Regards
Darshan
Hey Hi siva,
Use the following code:
Finaltable:
Load *,'OverUnderFDUS2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderFDUS2011.qvd](qvd);
concatenate
Load *,'OverUnderSTAFF2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderSTAFF2011.qvd](qvd);
Concatenate
Load *,'OverUnderILS2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderILS2011.qvd](qvd);
Concatenate
Load *,'OverUnderETCA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderETCA2011.qvd](qvd);
Concatenate
Load *,'OverUnderFDCA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderFDCA2011.qvd](qvd);
Concatenate
Load *,'OverUnderSTCA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderSTCA2011.qvd](qvd);
Concatenate
Load *,'OverUnderGACA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderGACA2011.qvd](qvd);
Store FinalTable into FinalTable.qvd (qvd);
TableName Field in the FinalTable.qvd will allow you to seperate the each table data on the selection in the front end(Optional).
Hope this solves your issue.
Regards
Hello Siva,
Try a few files only, and see how large the file is in the folder, or if it's zero size.
Can you post your code or attach the application so we can take a closer look?
Regards.
BI Consultant
Hi Miguel,
Sorry to say this I’m unable to post my code or attachment.Because it’s very confidential file.
Ok then,
What happens if you don't load all records from your file? Is the file empty?
ReducedTable:
LOAD *
FROM File*.qvd (qvd)
WHERE RecNo() < 10; // Load only 10 records from every file
BI Consultant
Hi Miguel,
I tried with above code also, but still final qvd was not showing any data.