How can I Consolidate QVD FILES with FOR?

[Aldemarprins4]

Hello guys, Is it possible to consolidate several QVD files with a FOR?

All files have the same structure

Thank you

[Oleg_Troyansky]

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,

[Aldemarprins4]

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*_*

[Oleg_Troyansky · Accepted solution]

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,

[rwunderlich]

Can you post your actual script statement? You seem to be missing .qvd (qvd).

-Rob

[Oleg_Troyansky]

Rob - jinx!

[Aldemarprins4]

thanks it works