Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to exclude a column from the qvd?
rather columns....while reloading it into another .qvw
Any example is appreciated
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.
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?
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.
LOAD * FROM x.qvd (qvd);
DROP FIELD FieldA, FieldG;
-Rob