Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead 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
jonathandienst
Partner
Partner

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

View solution in original post

4 Replies
jonathandienst
Partner
Partner

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
PrashantSangle

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.
jonathandienst
Partner
Partner

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
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;