Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys, Is it possible to consolidate several QVD files with a FOR?
All files have the same structure
Thank you
I'm not sure if '*_*' is a valid syntax... Try it with just one asterisk, and don't forget the extension and the qualifier:
LOAD * FROM
[lib://MyConnection/MyQVDFile*.QVD] (QVD);
Cheers,
You can probably do it with a FOR loop, if you really want to, but the easier way is to just load all of them using a wild card name:
LOAD * FROM [lib://MyConnection/MyQVDFile*.QVD] (QVD);
Cheers,
Thanks, but I have a little problem, the QVD files have the following name for example:
MyConnection/MyQVDFileChannel_Country
Where Channel can be an X, Y or Z and the country can be COSTA RICA, COLOMBIA or CHILE or any other COUNTRY and there are countries that do not have the 3 QDV there is one that only has a single QVD or a single CHANNEL, there are others that They have all 3 channels.
try as you say but no data appears
MyConnection/MyQVDFile*_*
I'm not sure if '*_*' is a valid syntax... Try it with just one asterisk, and don't forget the extension and the qualifier:
LOAD * FROM
[lib://MyConnection/MyQVDFile*.QVD] (QVD);
Cheers,
Can you post your actual script statement? You seem to be missing .qvd (qvd).
-Rob
Rob - jinx!
thanks it works