Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I have 10 qvd files. I want to make them into single qvd using concatenate function. But all 10 qvd files are dismilar fields. Is it possible to make single qvd for all 10 qvds?
thanks in advance.
Hi,
Yes you are able to create a single qvd by the 10 qvds but in this case you need to concatenate load all 10 tables then create a single qvd but in this case you need to handle null values because each table has disimilar fields.
Tab1:
load * inline
[
ColA,ColB
w,2
s,3
d,1
];
Concatenate
load * inline
[
ColC,ColD
u,7
i,6
o,5
];
Store Tab1 into Tab1.qvd;
Try to load by this code.
Hope this helps you.
Regards,
Anand
Hello Anand,
Thanks for giving replay
I tried with same way what you suggest. Table are also getting reloading and finally qvd also created. Here the proble is comming. I am unbale to open final qvd. What the porblem?
Hi,
You need to see your QVW application saved location on the folder where your QVW file is kept always a qvd file is create there. A qvd file Tab1.qvd is kept there after that you need to load it as a Table files from script window.
Regards,
Anand