How can we store limited number of fields in qvd??

[#1]

Hi,

I have a table having 10 columns for example fileld1, field2,....field10.But i need to store only 5 coulms as according to my choice in qvd. Can it be possible?.if yes, then how can i achieve that.

Regards,

Vasudha.

[jonathandienst · Accepted solution]

Use this syntax

STORE

     Field1,

     Field2

FROM DataTable1 into [myFile1.qvd] (qvd);

[PrashantSangle]

Hi,

Yes you can.

in your sql query or load statement instead of * include those 5 field only

Regards,

[jonathandienst]

If you want to do this dynamically, it would be better to export from a straight table. If you insist on doing this in the load script, then you will need to create a variable containing the comma-separated list of fields a,d then use that in the STORE statement - something like this (assuming that you are selecting values in a field called StoreFields:

• Create variable vList like this:     =Concat(StoreFieldsm ',')    // the = is part of the definition
• Then use a store statement like:

STORE

     $(StoreFields)

FROM DataTable1 into [myFile1.qvd] (qvd);

(This may show as a syntax error in the load script, but ignore that)

[Kushal_Chawda]

Field1, Field2 and Field3 are the fields of your choice in below table

Table:

load Field1

       Field2,

       Field3;

SQL SELECT *

FROM Table

store Table into Tablename.qvd;

drop table Table;