Qvd exclude column

[rdsuperlike]

How to exclude a column from the qvd?

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

Any example is appreciated

[simospa]

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;

S.

[rdsuperlike]

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?

[simospa]

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;

S.

[rwunderlich]

LOAD * FROM x.qvd (qvd);

DROP FIELD FieldA, FieldG;

-Rob