topic Re: Create multiple QVD's using single store statement in QlikView

Create multiple QVD's using single store statement

manideep78 — Mon, 15 Sep 2014 15:14:28 GMT

Dear Community,

I have doubt that is there a way that we can create multiple QVD files using single store statement. Let us assume 20 in this case. So can I create 20 QVD files using a single STORE command?

Regards,

Manideep

Re: Create multiple QVD's using single store statement

MK_QSL — Mon, 15 Sep 2014 15:19:37 GMT

FOR i = 0 to NoOfTables()-1

LET vTabNam = TableName($(i));

STORE $(vTabNam) into $(vTabNam).qvd (qvd);

NEXT i

Re: Create multiple QVD's using single store statement

Mon, 15 Sep 2014 15:36:35 GMT

Similar way...

FOR i = 1 to NoOfTables()

LET vTableName = TableName($(i)-1);

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO (qvd);

NEXT i