convert excel files and database tables to qvd

[#1]

Hi, how can I convert excel files and database tables to qvd format without downloading software? Thanks.

[#2]

if I dont drop table will it still read from qvd? or must i drop table then it'll read from qvd?

[vardhancse]

If you drop and data will be dropped.

ABC:

Load *

from table1;

STORE ABC into ABC.QVD;  -->this will create one QVD

DROP Table ABC;  --> This will drop the data in the QVD generator app

[#4]

Hi Rachel,

You will only drop the table if you do not want to use it in your model any longer.

Typically you'll drop a table when creating temp tables or when you are only loading data from source and writing to a .qvd. (Data loaders).

If you want to use the data inside your model you should not drop it.

Regards,
Marius

[shane_spencer]

Hi Rachel, it depends where you put the drop statement. You need to make sure it is not before the Store statement. The drop statement will drop the data from the QVW's memory, if it is after the Store statement it will not affect your QVD's. If you have a lot of data being loaded it is desirable to drop the data if it is no-longer needed.

[Anonymous]

Hi,

if the data you have in both sources is,by any chance,related and have any key then join and save the result table into qvd. If not, u need to use two qvds.

However,depends on requirement. Use store <table name> into name.qvd(qvd); to save into that format.

HTH

Ravi N.

[#7]

ok, so if i want it to read just from qvd then i should drop the table? but the problem is when i drop table, my charts cannot display the data because all the variables from the database tables are gone

[#8]

currently my script is like this:

tablename:

load *;

sql select *

from databasename.databasetable;

store tablename into $(vQVD)tablename.qvd;

drop table tablename;

[#9]

currently my script is like this:

tablename:

load *;

sql select *

from databasename.databasetable;

store tablename into $(vQVD)tablename.qvd;

drop table tablename;

convert excel files and database tables to qvd

[shane_spencer]

If you read from QVD you want to keep the data in memory (or qvw) so do not drop the table. You would want to drop the table if you've written to QVD and no-longer require the data in memory.

[its_anandrjs]

Not necessary to Drop the table if you want to read the QVD table then drop excel or SQL table and then read it from the QVD.

Hope this helps