That sounds like a very bad idea. Your table will look like this:
A B C D
3 - - -
4 - - -
1 - - -
- 1 - -
- 5 - -
- 2 - -
- - 3 -
- - 1 -
- - 6 -
- - - 2
- - - 1
- - - 2
If that's really what you want try this:
LOAD * INLINE [A];
FOR EACH vFile in FileList('C:\QVDATA\*.qvd')
LOAD * FROM [$(vFile)] (qvd);
Hi Gysbert ,
thanks a lot, works perfectly.
I know that is a bad idea but i think is the only one possibility to concatenate qvd's.
1. The loading will be from one table that contain all the datas. (qv_file: LOAD * FROM Table where code = var)
2. With multi-tasking scheduling we run many task of the same qv_file with a parameter (variable).
(in a command line will be: run qv_file /vvar=001,
in another command line will be: run qv_file /vvar=002
In this way we got all the data filtered with this variable, to have many qvd's that are called with a name of such variable. (qv_file_001.qvd, qv_file_002.qvd......)
Like that we can run so many task of the same file in parallel (that is not possible to have the same parallelism using QV server)
After that, in the front end all the qvd's will be concatenated together! And that was my question.
Do you have another idea for such topic, and about the concatenate? Your idea work so good, but maybe is not good with many datas.
Thank you, have a nice day!