topic Re: Create Multiple Qvds Using Single Store Statement in QlikView

Create Multiple Qvds Using Single Store Statement

sridhar423 — Tue, 02 Dec 2014 12:07:28 GMT

Hi All

I loaded 5 tables,and now i want to create 5 qvds with single store statement and i want to drop the tables at a time.

So, i used the below code for this

FOR i =0 to NoOfTables()-1

LET vTabName =TableName($(i));

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

DROP Table $(vTabName);

NEXT i

but i'm unable to create the qvd 2nd table and 4th table and i'm gettinng an error.When i start debugging loop is stepping from 1st table to 3rd table and next 5th table and next getting an error

Syntax error, missing/misplaced FROM:

STORE into .qvd (qvd)

STORE into .qvd (qvd).

Thanks in Advance

Sridhar.

Re: Create Multiple Qvds Using Single Store Statement

rubenmarin — Tue, 02 Dec 2014 12:16:50 GMT

Hi Sridhar, you can use:

FOR i =0 to NoOfTables()-1

LET vTabName =TableName(0);

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

DROP Table $(vTabName);

NEXT i

When you drop the table, the index of the other tables changes, so you always need to get the (0) table until all are droped.

Re: Create Multiple Qvds Using Single Store Statement

Tue, 02 Dec 2014 13:38:33 GMT

This works, you would need to define the table names (in my case they are 'ASCII', 'Transactions', 'Characters')

FOR Each vTable IN 'ASCII', 'Transactions', 'Characters'

STORE $(vTable) INTO $(vTable).qvd (QVD);

DROP Table $(vTable);

You can also create a subroutine and call the subroutine to store and drop the QVD.

SUB Create_QVD

STORE '$(vTable)' INTO QVD\$(vTable) (qvd) ;

DROP TABLE $(vTable);

END SUB

Re: Create Multiple Qvds Using Single Store Statement

sridhar423 — Wed, 03 Dec 2014 08:11:57 GMT

Thanks Ruben Marin its working.

Re: Create Multiple Qvds Using Single Store Statement

amit_saini — Wed, 03 Dec 2014 08:17:39 GMT

Sridhar,

If you want to store multiple tables then you have store it in multiple QVD files. You can store in QVD files using like this

STORE Table1 INTO Table1.qvd;

STORE Table2 INTO Table2.qvd;

STORE Table3 INTO Table3.qvd;

STORE Tablen INTO Tablen.qvd;

Or you can use For loop to store all tables in QVDs like below

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

STORE $(vTableName ) INTO $(vTableName).qvd (qvd);

NEXT vCount

Thanks,

Re: Create Multiple Qvds Using Single Store Statement

vireshkolagimat — Thu, 15 Dec 2016 15:05:13 GMT

Hi, I am loading the 3 csv files and trying to store all the 3 csv files as QVD. But the script is generating one qvd file which contains the data from all the 3 csv files. What if i need individual qvd for each file.

Thanks

Viresh

Re: Create Multiple Qvds Using Single Store Statement

rubenmarin — Thu, 15 Dec 2016 15:28:25 GMT

This can be caused because your 3 loads have the same structure and is autoconcatenating. To avoid this you can use the 'NoConcatenate' clause:

LOAD... FROM csv1

NoConcatenate LOAD ... FROM csv2

Re: Create Multiple Qvds Using Single Store Statement

vireshkolagimat — Fri, 16 Dec 2016 10:16:24 GMT

Thank you. Its working file.