topic Re: How can we store limited number of fields in qvd?? in QlikView

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

Tue, 22 Sep 2015 06:39:13 GMT

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.

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

jonathandienst — Tue, 22 Sep 2015 06:41:52 GMT

Use this syntax

STORE

Field1,

Field2

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

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

PrashantSangle — Tue, 22 Sep 2015 06:41:55 GMT

Hi,

Yes you can.

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

Regards,

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

jonathandienst — Tue, 22 Sep 2015 06:47:33 GMT

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)

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

Kushal_Chawda — Tue, 22 Sep 2015 07:04:29 GMT

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;