topic Qvd exclude column in QlikView

Qvd exclude column

rdsuperlike — Wed, 04 Feb 2015 22:14:23 GMT

How to exclude a column from the qvd?

rather columns....while reloading it into another .qvw

Any example is appreciated

Re: Qvd exclude column

simospa — Wed, 04 Feb 2015 22:30:17 GMT

Not sure I understood... what about this:

MyTable:

SQL SELECT field1, field2, field3 from your_table; //or LOAD... it depends from where you are starting!

STORE MyTable INTO myTable_qvd.qvd;

DROP MyTable;

//With this you reloaded only 2 columns...

MyTableReloaded:

LOAD field1, field3 from myTable_qvd.qvd

(qvd);

//...and if you want with this statement you overwrite the qvd

STORE MyTableReloaded INTO myTable_qvd.qvd;

Re: Qvd exclude column

rdsuperlike — Wed, 04 Feb 2015 22:41:14 GMT

yeah..in this case i have to mention all the fields i want and remove the ones i dont want.

What if i have 35 fields and want to exclude one.

Do I have any other way than writing all 34?

Re: Qvd exclude column

simospa — Wed, 04 Feb 2015 22:55:32 GMT

You can do this lazy boy 🙂 :

MyTable:

SQL SELECT field1, field2, field3 from your_table; //or LOAD... it depends from where you are starting!

STORE MyTable INTO myTable_qvd.qvd;

DROP MyTable;

EXIT SCRIPT;

//so now you created .qvd.

//after this, you can use the button that allows you to open local files (something like tabellar files or table fields, I have no English version) and use the wizard. Then you have the entire list of files, so you can remove what don't you use.

//remember to remove or comment the EXIT SCRIPT

//With this you reloaded only 2 columns...

MyTableReloaded:

LOAD field1, field3 from myTable_qvd.qvd

(qvd);

//...and if you want with this statement you overwrite the qvd

STORE MyTableReloaded INTO myTable_qvd.qvd;

Re: Qvd exclude column

rwunderlich — Thu, 05 Feb 2015 00:24:13 GMT

LOAD * FROM x.qvd (qvd);

DROP FIELD FieldA, FieldG;

-Rob