topic Re: QVD AMALGAMATION in QlikView

QVD AMALGAMATION

upaliwije — Sun, 25 Dec 2016 06:28:59 GMT

Hi Friends,

I have numer of QVD files to be amalgamaed to a single files.

AADEBIT.QVD

BADEBIT.QVD

APDEBIT.QVD

KADEBIT.QVD

GADEBIT.QVD

KUDEBIT.QVD

........

Can some one suggest me a method of writing a script to amalgamate them to single file at once without concatanating each file seperately

vinieme12 — Sun, 25 Dec 2016 08:15:32 GMT

See gwassenaar Response here

jayanttibhe — Sun, 25 Dec 2016 16:54:39 GMT

Hi Upali,

Seems that there is a pattern in your QVD names : if as you mentioned there are only First 2 characters are diff then we can do like this :

MyTable:

Load * from *DEBIT.QVD(qvd);

Store MyTable Into MyTable.qvd (qvd) ;

Thanks

Jayant Tibhe