Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Not applicable

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

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.

1 Solution

Accepted Solutions
Partner - Champion III

Use this syntax

STORE

Field1,

Field2

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies
Partner - Champion III

Use this syntax

STORE

Field1,

Field2

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Hi,

Yes you can.

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

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

Table:

Field2,

Field3;

SQL SELECT *

FROM Table

store Table into Tablename.qvd;

drop table Table;

Community Browser